--- [EMAIL PROTECTED] wrote: > Joe Wilson <[EMAIL PROTECTED]> wrote: > > The reason why I asked is that I haven't had much luck with sqlite3 > > performance for databases larger than the size of RAM on my machine > > regardless of PRAGMA settings. > > This is probably do to the cache locality problem. We know how > to fix this, Joe. Would you like to have a go at it?
I think setting aside contiguous pages in the file for exclusive use by each btree would help improve locality of reference on disk. For example, let A, B and C represent in-use pages of 3 btrees and a, b and c represent free pages corresponding to the same btrees: AAaAAaAaaaBBbbBBBbbbCCcCCCcccc Is this what you had in mind in your post? http://www.mail-archive.com/sqlite-users@sqlite.org/msg27851.html If not, could you elaborate? ____________________________________________________________________________________ Never miss a thing. Make Yahoo your home page. http://www.yahoo.com/r/hs ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------
