Hi, I have a CSV file that needs to be imported into a SQLite database and the contents of the CSV file should be inserted into various tables of the database.
1. Will using transaction speed up this opeartion of import? 2. Is the following method of using transaction correct or am I missing something ? sqlite3_exec(DBHandle,"begin transaction;", 0, 0, NULL); .....All the insert statements here sqlite3_exec(DBHandle,"COMMIT;", 0, 0, NULL); Thanks a lot! -- View this message in context: http://www.nabble.com/Transaction-Help-Please-tf2573591.html#a7174384 Sent from the SQLite mailing list archive at Nabble.com. ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------
