On Thu, 2005-03-24 at 15:31 -0500, Thomas Briggs wrote: > Well, I'm using the command line tool that comes with SQLite and > there is no ORDER BY clause in my query, so both the good news and the > bad news is that it certainly seems like something that SQLite is doing, > uhh... sub-optimally, shall we say. :) >
It appears that the btree is storing just a pointer to the result row data, not the result row data itself. So the complete result set is being kept in memory even if an external btree is used to index it. You are welcomed to experiment with changes that will store the entire result set row in the btree rather than just a pointer. If you can produce some performance improvements, we'll likely check in your changes. -- D. Richard Hipp <[EMAIL PROTECTED]>
