Re: SQL

Bill Welliver hww3@riverweb.com writes:

to clarify, my understanding is that big_query was useful in situations where the database would keep the data until it was requested (such as for large queries). then only the data requested would be retrieved. for obvious reasons, SQLite doesn't work that way, and might actually generate more overhead, mitigating one of its primary benefits (speed for small to moderately sized databases).

That's correct. of the "traditional" databases, only miniSQL dos stuff "in memory". Everybody else transfers data as they're fetched. Having both interfaces is needed for Sql.sql, which IIRC uses the one available to emulate the other if missing.