basically, that does not help me. There will be multiple requests coming to query the cache which will need data between limit and Offset. PageSize helps in how data is fetched from cache(i.e in batches of pageSize). but not for pagination to UI. For example, top 20 for 25th July, may be next request is top 20 highest payed employees. Without limit and offset, I will have to iterate through all records to get required ones.
On Thu, Jul 28, 2016 at 5:11 AM, vkulichenko [via Apache Ignite Users] < ml-node+s70518n6572...@n6.nabble.com> wrote: > You can query without OFFSET .. LIMIT and iterate through the QueryCursor, > it will automatically fetch data in pages. The page size is defined by > pageSize property on the query object. But this will only allow you to go > forward, you will not be able to return to previous page or go to any > random page. > > -Val > > ------------------------------ > If you reply to this email, your message will be added to the discussion > below: > > http://apache-ignite-users.70518.x6.nabble.com/Is-there-any-such-thing-as-SQlBuilder-in-apache-Ignite-for-SQLQuery-tp6541p6572.html > To unsubscribe from Is there any such thing as SQlBuilder in apache Ignite > for SQLQuery, click here > <http://apache-ignite-users.70518.x6.nabble.com/template/NamlServlet.jtp?macro=unsubscribe_by_code&node=6541&code=cmVkbmlydXNAZ21haWwuY29tfDY1NDF8Mzg4NjE2NTUx> > . > NAML > <http://apache-ignite-users.70518.x6.nabble.com/template/NamlServlet.jtp?macro=macro_viewer&id=instant_html%21nabble%3Aemail.naml&base=nabble.naml.namespaces.BasicNamespace-nabble.view.web.template.NabbleNamespace-nabble.view.web.template.NodeNamespace&breadcrumbs=notify_subscribers%21nabble%3Aemail.naml-instant_emails%21nabble%3Aemail.naml-send_instant_email%21nabble%3Aemail.naml> > -- View this message in context: http://apache-ignite-users.70518.x6.nabble.com/Is-there-any-such-thing-as-SQlBuilder-in-apache-Ignite-for-SQLQuery-tp6541p6595.html Sent from the Apache Ignite Users mailing list archive at Nabble.com.
