I've had similar speed increases using the same technique you've described for the last 10 revs of SQLite. I never had any noticable improvement when fiddling with the SQLite cache parameters. I just assumed it was a Linux thing. But maybe not.
> So what I tried next was to simply run my app after doing a > cat generaldb.db > /dev/null > (this takes about 15 seconds on my system, it's a 600Megs file) > > This has the effect of preloading the db file in memory in the OS caches. > > After I do this, the app becomes very fast (as in 4 times faster). > > note: I noticed that even if I specify some ridiculous number like > PRAGMA cache_size = 450000 (that should be enough to cache the whole db by > the way) > for the cache, the memory footprint of my app stays pretty low, as if it was > not caching much!? > > So at this point, I think the caching/polling subsytem seems to be the > problem. __________________________________________________ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com
