On Apr 6, 2012, at 5:54 PM, Joe Flemmings wrote:
Is their a flag to return the whole result set as it would kinda be expensive to add another select statement. The query is very extensive.
Unfortunately, no. It would require internal changes to libzdb to provide this and as I mentioned it would then use a lot more memory.
I assume the reason you need to know the full result set size is to allocate some data structure to hold the result? If that is the case, why not use a dynamic data structure such as a hash table or a dynamic array? Maybe even the vector ADT used by libzdb internally?