strongduanmu opened a new issue, #15995:
URL: https://github.com/apache/shardingsphere/issues/15995

   ## Feature Request
   
   Now, we use TPCC to test the performance of ShardingSphere-JDBC and find 
that the performance loss of addBatch and executeBatch is large, and the logic 
needs to be optimized.
   
   
![image](https://user-images.githubusercontent.com/10829171/157831442-b760111c-554b-47b5-9ffe-3d2687482e27.png)
   
   ### Is your feature request related to a problem?
   
   No.
   
   ### Describe the feature you would like.
   
   When we execute addBatch method every time, it will call 
createExecutionContext method. This logic is very time-consuming. We should 
consider passing all the parameters to the createExecutionContext method at one 
time to improve performance.
   
   ```java
       @Override
       public void addBatch() {
           try {
               executionContext = createExecutionContext(createLogicSQL());
               
batchPreparedStatementExecutor.addBatchForExecutionUnits(executionContext.getExecutionUnits());
           } finally {
               currentResultSet = null;
               clearParameters();
           }
       }
   ```
   


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

To unsubscribe, e-mail: 
[email protected]

For queries about this service, please contact Infrastructure at:
[email protected]

Reply via email to