On Thu, 22 Dec 2011 13:49:48 +0000, "Black, Michael (IS)"
<michael.bla...@ngc.com> wrote:
> You're probably seeing disk thrashing.
>
> Try increasing your database cache size:
>
> .pragma cache_size XXXXXX
Make that
PRAGMA cache_size=xxxxxx;
> It's in kilobytes.
Almost correct. Cache_size is in number of database pages.
So, if page_size is 1024, you're right.
> Try and make it as big as your database if you can.
> In other words, cache the whole thing.
>
[snip]
--
Regards,
Kees Nuyt
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
