
2 Nov
2012
2 Nov
'12
4:37 p.m.
On 02-11-2012 11:18:24 -0500, Percy Wegmann wrote:
Thanks, it's filed:
Thanks.
I documented the workaround, which is to not use bind parameters for limit and offset. The major impact here is that it prevents effective caching of the compiled query, since each combo of limit/offset ends up looking like a different query.
Not sure about that. The SQL compiler already factors out constants for queries before it caches them, e.g. select x from t where a > 10 uses the same plan as select x from t where a > 3. Fabian _______________________________________________ users-list mailing list users-list@monetdb.org http://mail.monetdb.org/mailman/listinfo/users-list