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).
bill
On Fri, 19 Dec 2003, Bill Welliver wrote:
but do you use big_query in ordinary useage? i don't remember the last time I used big_query()... just query().
bill
On Fri, 19 Dec 2003, Martin[iso-8859-1] B�hr wrote:
one of the differences between query() and big_query() is that the latter returns an object while the former does not.
it appears to me that sometimes the object interface is wanted even though a normal query would suffice.
i surely would not want to rewrite my apps just because the big_query() interface is not supported. how the actual querying is done is secondary.
greetings, martin.