My suggestion for a future enhancement: Provide a temporary storage pool of memory. If the temporary pool overflows then go to disk based temp store.
That way order by query results can generally be quickly satisfied by the average case memory consumption and Large order by queries will eventually spill to disk. Just a thought.... for your consideration. Thanks, Ken _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users