gongguoyu edited a comment on issue #6458: URL: https://github.com/apache/shardingsphere/issues/6458#issuecomment-717707017
@tristaZero thanks for your response. in my situation,i just need database-sharding ,no table-sharding, and all sql will run in the selected database. now batch insert 4000 rows will take 32s, and What can I do to improve the speed？ sql like this: insert into pressure(userid,orderid) values(?, ?),(?,?),... sharding-jdbc 4.0.0-RC2, MYSQL 5.7.12-log _the following is some of my log while batch insert 4000 rows: 2020-10-28 13:19:37.759 INFO 9960 --- [nio-9002-exec-1] c.h.s.test.config.ShardingJDBCConfig : HintShardingAlgorithm.doSharding 2020-10-28 13:19:37.759 INFO 9960 --- [nio-9002-exec-1] c.h.s.test.config.ShardingJDBCConfig : 数据库路由完毕. 2020-10-28 13:19:38.553 DEBUG 9960 --- [nio-9002-exec-1] c.h.s.test.mapper.MapperTest.insertData : <== Updates: 4000 2020-10-28 13:19:38.562 INFO 9960 --- [nio-9002-exec-1] c.h.sharding.test.controller.controller : sql: 30.554s_ ---------------------------------------------------------------- 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: [email protected]
