-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 On 13/01/12 14:35, Normand Mongeau wrote: > > It gets worse. On a clean empty database, the same 534 transactions > take 140 seconds. That's a not very impressive rate of 3.8 inserts > per second. The FAQ says that SQLite should be able to do a "few dozen > transactions per second". I'd be happy to see that.
What file extension are you using for the database? There is a long list of extensions that System Restore monitors, and makes backups of the files as they change. This will kill your performance. Extension list and terse details are at: http://msdn.microsoft.com/en-us/library/Aa378870 Roger -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.11 (GNU/Linux) iEYEARECAAYFAk8Quc4ACgkQmOOfHg372QQAowCgi0DlewfcHs6MIPIHSyjHw6mN nFIAnjJch3erZfRF+I88yA3CzAkCQWVl =HoSZ -----END PGP SIGNATURE----- _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
