?????? SO slow to insert 5K record one time using Sharding-JDBC

Dear Yonglun, Thanks for your suggestion. it costs about 1s now by upgrading the version. However, we found another issue of that some SQL works well in old version, but not work in new version. Thanks. Terry ---- ??:

Re: SO slow to insert 5K record one time using Sharding-JDBC

It is the parsing module cost so much time. You can update the Sharding-JDBC to 4.1.0 or above to solve the problem. Please refer to the release notes of 4.1.0: https://github.com/apache/shardingsphere/releases/tag/4.1.0 -- Zhang Yonglun Apache ShardingSphere Terry Zhang 于2020年8月4日周二

SO slow to insert 5K record one time using Sharding-JDBC

Hi, ShardingSphere community, We are using Sharding-Sphere 4.0.RC2 in our project for a long time. Recently, we are encountering a serious issue struggling us. When we try to insert 5K records one time into one table, it takes about 40 seconds. However, when the execution time is about 0.11