Help -- the need for speed

From: J. R. Baker <jrbaker_at_ccgate.hac.com>
Date: Thu, 08 Apr 1999 15:58:49 -0700
Message-ID: <370D34A9.8AE60546@ccgate.hac.com>

My group is trying to jam data into ORACLE as fast as possible. We get the data from a flat file, generate INSERT statements, and send them to ORACLE 8 using OCI calls (in MS C++).

This works, but we are looking for speed. One way we increase speed is to launch multiple threads on the client and open a database connection per thread. This works great in SYBASE and perhaps less great in ORACLE.

One problem is: we have lots of triggers in our database. If we turn triggers off, the data loads 5 times faster. This implies a server-side bottleneck. Right ?? Any ideas ??

Another problem: When we get above about 15 connections, ORACLE just loses a connection now and then. Even when the connection has already been running a while, Oracle just seems to lose it. Anyone seen this type of thing before ? It seems much less graceful than Sybase. Sybase was able to go to 50 connections with no problem and was very well mannered if you asked for too many.

Thanks in advance for any advice on these topics.

John Baker Received on Thu Apr 08 1999 - 17:58:49 CDT