[GitHub] [incubator-shardingsphere] wy-coder commented on issue #1997: Force route is a one time thing, should not be a Hint Strategy which have Algorithm.

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

wy-coder commented on issue #1997: Force route is a one time thing,should not be a Hint Strategy which have Algorithm.
URL: https://github.com/apache/incubator-shardingsphere/issues/1997#issuecomment-470774537
 
 
   That is to say：
   
   All jdbc supports full table **paging** scanning , but sahrding does not.
   
   if do not support force route to a specify database, how to do full table **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