Lloyd <[EMAIL PROTECTED]> wrote: > Hi, > When this 3M inserts are performed, it takes 130 more seconds compared > to the actual application running time. The actual application run time > is 20 seconds but when this 3M inserts are performed it takes 150 > seconds. > > Is there any way to reduce the time ? >
1. Use prepared statements 2. Reduce the number of indices on the table, or add the indices after all data has been inserted. -- D. Richard Hipp <[EMAIL PROTECTED]> ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------