johnny2002 commented on issue #6458: URL: https://github.com/apache/shardingsphere/issues/6458#issuecomment-671215272
> @johnny2002 Got it. Thanks for your further clarification. > Just to confirm, you have the `sharding tables` and these `hint tables` meanwhile, don't you? > Your particular case made me feel you only use shardingJDBC for routing the SQL to specific DB of the DB cluster. If so, why do not you use multiple independent MySQL instances instead? > > I just wanna get other advantages of your suggestion for `hintManger` apart from skipping parsing and rewriting. other advantages has been stated on your official document already: “Users can use hintManager.setDatabaseShardingValue to add shardings in hint route to some certain sharding database without sharding tables.**After that, SQL parse and rewrite phase will be skipped and the _overall enforcement efficiency can be enhanced_**” redarding "why do not you use multiple independent MySQL instances instead", in one application, since I have already configured one Shardingsphere datasource, I don't want to repeat configure for several datasources. Otherwise, I need to implement another datasource route routine. ---------------------------------------------------------------- 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: [email protected]
