--- Al Danial <[EMAIL PROTECTED]> wrote:
> On 7/21/05, Chuck Pahlmeyer - MTI <[EMAIL PROTECTED]> > wrote: > > I have an application in which I'd like to create a > database as > > quickly as possible. The application has a batch > process at > > startup which creates the data. I am using a single > transaction > > for all of the INSERT statements. I'm also using > prepared statements > > to alleviate some of the overhead for processing SQL > text. Typical > > table sizes are on the order of a few million rows. I > can get > > about 50,000 rows/second on my 3GHz Linux system, but > would like to > > do better. > Maybe it's obvious, but worth mentioning that if you have many (or complex) indexes on the target table, insert speed could be affected. If you have the option, it might go faster to complete the inserts, then add whatever indexes your app requires. -Clark
