LostMyth commented on issue #31374: URL: https://github.com/apache/shardingsphere/issues/31374#issuecomment-2134860996
> The data in a database can only have one storage structure. It maybe not a good practice to having more than one sharding strategies in the same table. Thanks very much for answer my question. I am using shardingjdbc-4.1.1 in my project, in this version it is possible to configure two logical tables for the same physical table, corresponding to standard routing, and forced routing respectively. The standard route is used in normal business, and the forced route is used when exporting table data. Now I want to upgrade to Shardingsphere-jdbc-5.5.0, if I can't use forced route to scan table data and then export, I have to do standard route to scan each table. This will result in wasted queries, so is there any other method other than forced routing that will help to export all the sub-table data? -- 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. To unsubscribe, e-mail: [email protected] For queries about this service, please contact Infrastructure at: [email protected]
