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/03/14 09:53:31 UTC

[GitHub] [incubator-shardingsphere] ratyzhang commented on issue #290: Support batch INSERT

ratyzhang commented on issue #290: Support batch INSERT
URL: https://github.com/apache/incubator-shardingsphere/issues/290#issuecomment-472779712
 
 
   @terrymanu 亮哥
   INSERT INTO t_table_yymmdd (xx, xx,....M) VALUES
   (xx,xx,....M),
   (xx,xx,....M),
   (xx,xx,....M)
   ....N
   当M(字段数)*N(记录数)比较大，进行分表操作时，如500*20时，sql执行非常慢，基本上卡死了。根据debug 应该问题出在 sqlRoute 和 sqlParse 这块。请确认。

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


With regards,
Apache Git Services