On Sun, Feb 22, 2009 at 11:44 PM, jose isaias cabrera
<cabr...@wrc.xerox.com> wrote:
>>
>> Try this:
>> pragma cache_size=10000;
>> pragma page_size=16384;
>> vacuum;
>
> Wow, thanks.  That did help. Cool, so there was something that I could do.
> Here is a question: this DB is shared by other folks, do they each need to
> set this when they open or if I set it, it would apply to everyone that
> connects to it?
>

"page_size" will persist once you've done the VACUUM.  "cache_size"
doesn't persist, but you can use "default_cache_size" if you want it
to.

http://sqlite.org/pragma.html

-- 
Matthew L. Creech
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Reply via email to