I don't mean to pick on the OP, but this is such a commonly asked question for people new to SQLite (including me not so long ago) that maybe putting something like what you just said many places on the website (besides just the Wiki) would help. Perhaps on the INSERT doc page? And maybe make it bold?
Doug > -----Original Message----- > From: [EMAIL PROTECTED] [mailto:sqlite-users- > [EMAIL PROTECTED] On Behalf Of D. Richard Hipp > Sent: Wednesday, October 15, 2008 3:16 PM > To: [EMAIL PROTECTED]; General Discussion of SQLite Database > Subject: Re: [sqlite] basic insert questions... > > > 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 _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
