Re: Multiple inserts => multiple connections

I am actually using the Array interface from OCI. Each second I prepare

    the statements using the array interface and then executes them by calling OCIStmtExecute as follows:

if ( (status = OCIStmtExecute(

                sc->svchp,
                stmthp,
                errhp,
                (ub4) maxiters,
                (ub4) 0,
                (CONST OCISnapshot *) NULL,
                (OCISnapshot *) NULL,
                OCI_COMMIT_ON_SUCCESS)) != OCI_SUCCESS) {

Thanks!
Ole

Jim Kennedy wrote:
> 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

>>Br,
>>Ole
>>