--- [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:


Is this what you had in mind in your post?


If not, could you elaborate?

Never miss a thing.  Make Yahoo your home page. 

To unsubscribe, send email to [EMAIL PROTECTED]

Reply via email to