I have not done that yet; I'll get it into that state then attach to sqlite3's command line tool and see if I can learn something. I will let you know what I find.
-----Original Message----- From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Pavel Ivanov Sent: Wednesday, October 07, 2009 2:23 PM To: pechni...@sandy.ru; General Discussion of SQLite Database Subject: Re: [sqlite] Insert speed greatly decreasing over time > 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 _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users