Hi all, I have a question about transactions and SQLite: Do you think transactions are useful only when you have to do a sequence of statements that depends on each other and you need a way to rollback all statements if something goes wrong? or you can use transactions even with not interdependent statements for performance reason? and if yes do you think there's a trade-off about the number of query number in each transaction?
I'm think about 1000 INSERT query to execute, is transaction works better because you do not have to change index at any insert but just one time on commit? _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
