Re: [sqlite] page cache vs OS cache

I'd say the performance of a local in-process cache can be comparable with performance of OS cache only in one case: if your process is the only process in the system and no other files are read from disk. In all other (common) cases OS caches much larger set of data than is used by SQLite and natu

Re: [sqlite] page cache vs OS cache

On Sat, Nov 20, 2010 at 5:44 AM, Yang wrote: > I wonder why we need page cache, since we already have OS file cache. > > in other words, if we simply set OS cache to be very large, would it > have the same effect as page cache? > > Yang, sqlite operates on some level of abstration. For example, i

[sqlite] page cache vs OS cache

I wonder why we need page cache, since we already have OS file cache. in other words, if we simply set OS cache to be very large, would it have the same effect as page cache? thanks Yang ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlit