SQL_CALC_FOUND_ROWS equivalent?
Hi, is there any function or trick in Monet equivalent to mysql "SELECT SQL_CALC_FOUND_ROWS ..." to get de total rows when limit is present ? ((pagination) So I could get de TOTAL rows/pages number without exec another query everytime I need paginate results. Thanks!
Hai Alberto, Nop, no such function ready-for-use. It should be easy to implement a UDF for this. Jennie
On 1 Sep 2017, at 16:08, Alberto Ferrari <aferrari@starconnecting.com> wrote:
Hi, is there any function or trick in Monet equivalent to mysql "SELECT SQL_CALC_FOUND_ROWS ..." to get de total rows when limit is present ? ((pagination)
So I could get de TOTAL rows/pages number without exec another query everytime I need paginate results.
Thanks!
_______________________________________________ users-list mailing list users-list@monetdb.org https://www.monetdb.org/mailman/listinfo/users-list
Thank you Ying, sorry for late response. Could you (or somebody) help me with that UDF function? I would like the function do not affect the performance of the SELECT query. Thanks again. 2017-09-05 9:23 GMT-03:00 Ying Zhang <Y.Zhang@cwi.nl>:
Hai Alberto,
Nop, no such function ready-for-use. It should be easy to implement a UDF for this.
Jennie
On 1 Sep 2017, at 16:08, Alberto Ferrari <aferrari@starconnecting.com> wrote:
Hi, is there any function or trick in Monet equivalent to mysql "SELECT SQL_CALC_FOUND_ROWS ..." to get de total rows when limit is present ? ((pagination)
So I could get de TOTAL rows/pages number without exec another query everytime I need paginate results.
Thanks!
_______________________________________________ users-list mailing list users-list@monetdb.org https://www.monetdb.org/mailman/listinfo/users-list
_______________________________________________ users-list mailing list users-list@monetdb.org https://www.monetdb.org/mailman/listinfo/users-list
participants (2)
-
Alberto Ferrari -
Ying Zhang