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/11/01 02:31:34 UTC

[GitHub] [incubator-shardingsphere] zhuobinchan commented on issue #3427: batch insert sql can improve efficiency?

zhuobinchan commented on issue #3427: batch insert sql can improve efficiency?
URL: https://github.com/apache/incubator-shardingsphere/issues/3427#issuecomment-548642342
 
 
   > the same configuration.
   > `Raw Insert` insert 10,000 rows data use 1.759s
   > `Sharding table` insert 10,000 rows data use 10.42s
   
   I found sharding table insert 10000 rows in one sql slower than 500 rows in 20 sql，because sql longer parsing sql slower？

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