[GitHub] [shardingsphere] piggytough opened a new issue #7809: How to improve efficiency of batch insert ?

Fri, 16 Oct 2020 01:23:24 -0700 


piggytough opened a new issue #7809:
URL: https://github.com/apache/shardingsphere/issues/7809


   **My version** : Sharding-JDBC 4.1.1
   
   sql like this: insert into pressure(userid,orderid) values(?, ?),(?,?),...
   insert data size is 5000, and i've used prepare statement.
   
   when NOT using sharding, time consumes about 40ms, but sharding takes about 
400ms.
   
   Sharding tables configuration:
   
![image](https://user-images.githubusercontent.com/43106779/96233774-1af56680-0fcb-11eb-9c85-99364b1c4932.png)
   
   Analysis by arthas, I can see that time mostly cost on function 
`org.apache.shardingsphere.sharding.rewrite.token.generator.impl.keygen.GeneratedKeyInsertValuesTokenGenerator:isToAddDerivedLiteralExpression`.
 See below: 
   
![batchinsert](https://user-images.githubusercontent.com/43106779/96232090-783ce800-0fca-11eb-8320-482c45adc4d7.png)
   
   Is there anything I can do to improve efficiency?
   
   
   


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

Reply via email to