On 13 Jan 2012, at 10:35pm, 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.
The figures you are getting are so slow they're a definite sign something is wrong. > I don't have much experience with SQLite, but where does one start when one > wants to troubleshoot such issues? Create a new user account on that computer. Reboot. Log into it. Try running the same application doing the same thing. But I think you may have already done a better test: run it on a different computer which has no anti-virus package running. Presumably your computer isn't malware-ridden, and is performing reasonably quickly when running other applications, for instance, that it can start up Word in less than 30 seconds. Simon. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
