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 2019/10/31 11:16:48 UTC

[GitHub] [incubator-shardingsphere] zhuobinchan opened a new issue #3427: batch insert sql caneff improve efficiency?

zhuobinchan opened a new issue #3427: batch insert sql caneff improve efficiency?
URL: https://github.com/apache/incubator-shardingsphere/issues/3427
 
 
   ## Question
   batch insert 10000 record by default  just need 2~3 second，but use sharding-jdbc insert need more than 2 minutes。
   how to optimize it to improve efficiency？
   
   maven version：
   ![image](https://user-images.githubusercontent.com/15796879/67942417-bce13f00-fc12-11e9-9f23-e0a46f4fa8bb.png)
   
   test case result：
   ![image](https://user-images.githubusercontent.com/15796879/67942458-cf5b7880-fc12-11e9-806e-ff061ec17cdb.png)
   
   database：Mysql 5.7
   
   

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