You are viewing a plain text version of this content. The canonical link for it is here.

Posted to dev@shardingsphere.apache.org by GitBox <gi...@apache.org> on 2019/01/25 07:40:57 UTC

[GitHub] feelwing1314 opened a new issue #1820: the replaySetParameter cost much time on mysql batch insert.

feelwing1314 opened a new issue #1820: the replaySetParameter cost much time on mysql batch insert.
URL: https://github.com/apache/incubator-shardingsphere/issues/1820
 
 
   ## Feature Request
   
   Test follow:
   INSERT INTO tb_credit_info_1 (col1, col2, co3, ... col27),(col1, col2, co3, ... col27),(col1, col2, co3, ... col27) .....
   
   1. There are 27 column in tb_credit_info_1;
   2. batch 2000 insert .
   
   the replaySetParameter() in AbstractShardingPreparedStatementAdapter cost 1.5 seconds，this is Unacceptable。
   
   i think the reason is that it requires 52000 ( 27*2000 ) reflection invoke.
   

----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on 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


With regards,
Apache Git Services