lif123 commented on issue #23635: URL: https://github.com/apache/shardingsphere/issues/23635#issuecomment-1396374028
Thanks for your reply. Union all same database is a great feature which can improve performance . In my select case : select from logic_table where id in (?,?,?,?,?). Union all will cost more time than execute one by one, this is clear. If your time cost > [max_execution_time](http://dev.mysql.com/doc/refman/5.7/en/server-system-variables.html#sysvar_max_execution_time), then mysql will interrupt your sql execution. Unfortunately your DBA do not allow increase max_execution_time :( .So now I just shard myself on application and then execute sql to avoid this issue. --- So is there any possible we can control Union logic (sql number or turn off ) ? thanks -- 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]
