[GitHub] [shardingsphere] gongguoyu edited a comment on issue #6458: How to skip sql parse and rewrite phase

[GitBox <gi...@apache.org>]

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 and no table-sharding. 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:
users@infra.apache.org