On 15 Jun 2009, at 10:11pm, Mike Borland wrote: > > When I start the 900 read iterations (always in the same order), the > first one generally reads in about 50ms and by the last read, it's > taking roughly 1000ms. Sometimes it slows down immediately, > sometimes after the 100th iteration.
Put some code in your application that closes and reopens the database after iteration 500 (or every 100). See if it speeds up when you've just done that. If it does, the bug is somewhere in your code or SQLite. If it doesn't, the bug is somewhere in memory management or disk access. Simon. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
