-----Original Message----- From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org] On Behalf Of John Drescher Sent: Tuesday, July 13, 2010 12:37 PM To: General Discussion of SQLite Database Subject: Re: [sqlite] Sqlite Insert Speed Optimization
> I also wrap my statements (about 500 inserts at a time) with a > begin/end transaction. > After these 500 i take a few seconds to read more data so sqlite > should have time to do any housekeeping it might need. > Wrap more into a transaction. 500 is too small of a percentage of a million. John ==================== John, I was wondering if that's really so. Wouldn't the marginal speed improvement be quite small? Is the percentage of the final rowcount really a criterion? _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users