I recall reading that you should set the page size to the cluster size of your disk. I think 4KB clusters are typical on Windows, and the SQLite cluster size is 2KB if I remember correctly, so I bumped that up. I've played around with increasing the cache_size by 2x - 4x and it helps as well, but I'm not aware of any rules of thumb.
> -----Original Message----- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On > Behalf Of L B > Sent: Friday, April 18, 2008 9:11 AM > To: General Discussion of SQLite Database > Subject: Re: [sqlite] in memory or hard disk reading? > > Thanks Doug. > Is there any suggestion or rules about parameters to use (cache_size, > default_cache_size...) in relation to database size and number of records in a table? > > > --------------------------------- > Be a better friend, newshound, and know-it-all with Yahoo! Mobile. Try it now. > _______________________________________________ > 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
