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