[sqlite] Multiple connections and page cache(s) reusability

Thanks for the reply. Therefore my expectation that the approach 3 should be the best is correct, isn't it? I mean, using a dedicated connection for each table should cause better reusablility of cached pages? Or what approach would you propose to get the best performance? Does SQLite have any o

[sqlite] Multiple connections and page cache(s) reusability

Milan K??? wrote: > My understanding was that each connection has its own page cache. This is correct. > [...] Does SQLite have yet some other global cache? No. That other global cache is part of the OS. It might be possible that opening a file two times changes the OS's caching algorithm. R

[sqlite] Multiple connections and page cache(s) reusability

Hello, I have a question regarding caching mechanism in SQLite. Especially when using multiple connections. My understanding was that each connection has its own page cache (if I don't use SQLITE_OPEN_SHAREDCACHE). However I wrote some tests and results didn't met my expectations... So what I t