Re: Multiple inserts => multiple connections

You have a defect in the code doing the inserts. There is no good reason to multiple connections from a client and certainly not to do all those inserts on them. (1 connection/insert ugh) A better strategy to do inserts faster would be to use the array interface and send over multiple rows to be inserted at a time.

My guess is that this is some application ported from SQLServer and it opens connections al over the place and probably commits after each one. Jim

"Ole Hansen" <oha_at_city.dk> wrote in message news:3E0B299D.9040406_at_city.dk...
> Hi,
>
> I have a problem with too many connections/processes. I'm having an
> application connecting to the server but for some reason the number of
> processes or connections increases to exceed the limit.
>
> On startup the number of connections is 2-3 but when doing multiple
> inserts (150-200 pr. sec.) the number of connections increases until the
> server crashes.
>
> Is it possible to remove or control unused connections from the
 application?
>
> Br,
> Ole
>
Received on Thu Dec 26 2002 - 17:22:13 CET