Many thanks for your response. That solved the problem. Now I update data for all 124 bases in about eight seconds.
RobR -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Petite Abeille Sent: Tuesday, February 14, 2012 2:18 PM To: General Discussion of SQLite Database Subject: Re: [sqlite] A faster way to insert into a keyless table? On Feb 14, 2012, at 8:01 PM, Rob Richardson wrote: > What would be the best way to speed this up? wrap all your inserts in one transaction. commit at the end. _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
