Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

new possible feature for pagination #7089

Closed
publicocean0 opened this issue Jan 17, 2017 · 0 comments
Closed

new possible feature for pagination #7089

publicocean0 opened this issue Jan 17, 2017 · 0 comments
Assignees

Comments

@publicocean0
Copy link

publicocean0 commented Jan 17, 2017

i m improving my jquery plugin for pagination adding also pagination by rid.
In general case i have a high number of pages and preload all rid page could be huge. So it is necessary to use a lazy method.
if i go forward in the navigation i can always to find the new page rid because

  • or is in the plugin cache
  • i can execute (page-1)*pageSize skip pageSize for finding the new rid and page (page -1 is known if i go forward).
    If i go backward instead and i dont know the rid (not previously read)
    i might execute (page)*pageSize skipback pageSize (i know page rid)

so a new possible feature is to introduce SKIPBACK keyword :)
example
select from A where @Rid< #5:1000 skipback 10;

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Development

No branches or pull requests

3 participants