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 ? Thnaks, Lloyd. On Mon, 2006-10-23 at 08:44 -0600, Dennis Cote wrote: > Lloyd wrote: > > Hi, > > How much time it may take to "insert or ignore into query" for 30 > > lakhs times. It adds more than 130 sec overhead compared to the 20 sec > > of execution time. All these are done inside a single transaction. And > > these insertions are made on three tables (on each table 10 lakhs) with > > a combined primary key of text and integer. > > > > Is this the expected performance? Can I improve it anyway? (I am using > > the wxSQLite wrapper class) > > > > Thanks, > > Lloyd. > > > > > > ______________________________________ > > > All, > > FYI, a lakh is defined as: > > A lakh (also spelled lac or laksha) is a unit in a traditional number > system, still widely used in India and Bangladesh, equal to a hundred > thousand. A hundred lakhs make a crore. > > So Lloyd is doing 3M insert or ignores. > > Lloyd, > > What do you mean by "130 seconds of overhead"? > > Dennis Cote > > > ----------------------------------------------------------------------------- > To unsubscribe, send email to [EMAIL PROTECTED] > ----------------------------------------------------------------------------- ______________________________________ Scanned and protected by Email scanner ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------
