> Try this: > pragma cache_size=200000; I believe changing pragma cache_size will not help, because size of the database doesn't change, so cache hit ratio doesn't change too. And there's no disk i/o suggesting that it's not the bottleneck.
Chris, did you try to attach to the process with some debugger to see what it is doing (at least in what function it's located) when there's no cpu and i/o? Pavel On Wed, Oct 7, 2009 at 2:19 PM, Alexey Pechnikov <pechni...@mobigroup.ru> wrote: > Hello! > > Try this: > pragma cache_size=200000; > > Best regards, Alexey Pechnikov. > http://pechnikov.tel/ > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
