[GitHub] [incubator-shardingsphere] wy-coder opened a new issue #1998: Full table **no sort paging** scanning

[GitBox <gi...@apache.org>]

wy-coder opened a new issue #1998: Full table **no sort paging** scanning
URL: https://github.com/apache/incubator-shardingsphere/issues/1998
 
 
   ## Feature Request
   
   **For English only**, other languages will not accept.
   
   Please pay attention on issues you submitted, because we maybe need more details. 
   If no response **more than 7 days** and we cannot make decision by current information, we will **close it**.
   
   Please answer these questions before submitting your issue. Thanks!
   
   ### Is your feature request related to a problem?
   
   #1997 
   
   ### Describe the feature you would like.
   That is to say：
   
   All jdbc supports full table **no sort paging** scanning , but sahrding-jdbc does not.
   
   if do not support force route to a specify database, how to do full table **no sort paging**?
   
   limit 200 300
   
   db1 : limit 0 300
   db2 : limit 0 300
   db3 : limit 0 300
   assemble and sort 0 900
   
   limit 200 300 from 0 900
   This is not efficient.
   
   we need:
   node1 : db1 : limit 0 100
   node2 : db1 : limit 100 200
   node3 : db1 : limit 200 300

----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
 
For queries about this service, please contact Infrastructure at:
users@infra.apache.org


With regards,
Apache Git Services