On Oct 15, 2008, at 4:01 PM, Jay A. Kreibich wrote: > > Issue the command "BEGIN", do 100 to 10000 INSERTs, issue a "COMMIT". > You should see a very noticeable difference in speed. >>
Just to amplify Jay's words: On a workstation, SQLite should do at least 50,000 INSERTs per second. But due to limitations of spinning disk drives, you can get at most 60 transactions per second. If you do not use BEGIN...COMMIT, then each INSERT is a separate transaction, regardless of whether or not they are in the same string. By doing the BEGIN...COMMIT with the INSERT statements in between, you can do thousands and thousands of fast INSERTs for each relatively slow COMMIT. D. Richard Hipp [EMAIL PROTECTED] _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
