> > One more thing, did raising the limit on the number of pages SQLITE > > can cache internally have any effect? > > I just tried (hadn't noticed that option before) to go from 2000 to 4000 > and 8000, without noticing any difference. I might try next week to > raise the page size to 50k and see if it makes a difference?
On an OS with file caching, this sqlite page cache setting will benefit write transactions more than reads. __________________________________________________ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------
