Is there any pagination functionality in SnappyData using sql? For example, there are 10000 records in a table. Can we do a query to “get 10 entries starting from 1000 to 1010”? We need this to support pagination feature in our REST API.
Asked
Active
Viewed 68 times
0
-
Currently pagination is not supported in SnappyData but will be approximated using an "offset" clause in the next version (1.1) – plamb Feb 27 '18 at 16:50
-
You can also try using SCROLL_INSENSITIVE or rank() to achieve something similar – plamb Feb 27 '18 at 16:51
-
Thanks this helps – 1012ankur Jun 08 '18 at 05:54