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. ______________________________________ Scanned and protected by Email scanner ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------
