Hi, I am importing a CSV file into a SQLite database. While doing the import i am enclosing the insert statements between "BEGIN TRANSACTION;" and "COMMIT TRANSACTION;"
The first time i do the import, everything is fine (its fas enough). Performance decreases drastically when I try to import the same CSV file again. Since I have a progress bar, I can clearly see a preformance decrease for consecutive imports. Each time I only import less than 500 records. Is there something that I need to do in order to get consistent performance? Thanks a lot for your help! -- View this message in context: http://www.nabble.com/Slow-Transaction-tf2580862.html#a7194323 Sent from the SQLite mailing list archive at Nabble.com. ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------