You are viewing a plain text version of this content. The canonical link for it is here.

Posted to notifications@shardingsphere.apache.org by GitBox <gi...@apache.org> on 2020/08/06 07:59:08 UTC

[GitHub] [shardingsphere] wenweibin edited a comment on issue #6665: sharding jdbc do not support batch update

wenweibin edited a comment on issue #6665:
URL: https://github.com/apache/shardingsphere/issues/6665#issuecomment-669774733


   1.I don't think it will be supported in the future, because this kind of SQL may be routed to multiple data nodes, which will cause distributed transaction problems.
   2. Just split batch SQL into a single sql , actually，batch update SQL with semicolon  is just a pseudo batch-update , and the mysql server is still executed one by one, which can only cut a little network overhead, and the performance improvement is very limited.


----------------------------------------------------------------
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