ignite-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From begineer <redni...@gmail.com>
Subject Re: Is there any such thing as SQlBuilder in apache Ignite for SQLQuery
Date Thu, 28 Jul 2016 18:05:48 GMT
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+s70518n6572h96@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.
Mime
View raw message