Re: Multi-threaded OCI Application Does Not Scale

From: Alexander Miroshnikov <alexander_miroshnikov_at_hotmail.com>
Date: Mon, 27 Jan 2003 20:44:23 -0000
Message-Id: <1043700368.81639.0@demeter.uk.clara.net>

> I have written a multi-threaded (pthreads) OCI program that INSERT's
> large quantities of data into an Oracle database. It works very
> reliably but does not scale well at all.
One of the possible reasons for the delays might be your memory-allocation routine. If threads make calls to the global memory manager that serialises mallocs using mutexes this can cause excessive waits, which are not related to Oracle at all.

Kind Regards,
Alex Received on Mon Jan 27 2003 - 14:44:23 CST