[Monetdb-developers] mapi_fetch_reset
-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA512
Hi,
Is it theoretically possible that the result set is too big for mapi_fetch_reset to work, so it is actually not brought back to the first result? (Opposed to the first result in the cache)
I'm having the following optimalisation issue; I can request a set of points in one go, but I need to reprocess them in two outputs.
- - I can place two queries, second one with a subselect - - I can place one query with a subselect (process it twice, see question one) - - I can store the outcome of query one, and then use an IN (...) pattern build from the first query output. - - I can store desired outcome in a temporary buffer, and place it on the end, using the one query subselect approach.
Option one uses two queries, sounds slow, option two is related to quetion one, I have seen option 3 fail for huge sets, Option 4 can take up twice as much memory.
Suggestions? :)
Stefan
participants (1)
-
Stefan de Konink