You are viewing a plain text version of this content. The canonical link for it is here.
Posted to notifications@shardingsphere.apache.org by GitBox <gi...@apache.org> on 2021/11/16 01:52:26 UTC

[GitHub] [shardingsphere] xr2117 commented on issue #13615: After inserting data, saveBatch is split into one insert instead of batch insert

xr2117 commented on issue #13615:
URL: https://github.com/apache/shardingsphere/issues/13615#issuecomment-969661240


   Mybatis savebatch method used
   
   
   
   Print SQL
   
   INSERT INTO internal_questions (
   	pick_count,
   	parent_id,
   	is_choice,
   	questions_type_id,
   	questions_type_name,
   	questions_type_detail_id,
   	questions_type_detail_name,
   	content,
   	answer,
   	line_number,
   	option_a,
   	option_b,
   	difficulty_id,
   	difficulty_name,
   	is_charged,
   	is_group_question,
   	origin,
   	upload_batch,
   	examine_status,
   	is_down,
   	is_check,
   	create_time,
   	create_by,
   	update_time,
   	update_by,
   	is_deleted 
   )
   VALUES
   	(
   		?,
   		?,
   		?,
   		?,
   		?,
   		?,
   		?,
   		?,
   		?,
   		?,
   		?,
   		?,
   		?,
   		?,
   		?,
   		?,
   		?,
   		?,
   		?,
   		?,
   		?,
   		?,
   		?,
   		?,
   		?,
   	? 
   	)
   
   config:
   
   spring:
     shardingsphere:
       props:
         sql-show: true
       datasource:
         common:
           driver-class-name: com.mysql.cj.jdbc.Driver
           type: com.alibaba.druid.pool.DruidDataSource
         names: ds1
         ds1:
           password: xxx
           url: xxx
           username: xxx
       rules:
         sharding:
           key-generators:
             snowflake:
               props:
                 max-vibration-offset: 2048
                 worker-id: 1
               type: SNOWFLAKE
           sharding-algorithms:
             tbstrategy:
               props:
                 algorithm-expression: questions_$->{id % 2 + 1}
               type: INLINE
           tables:
             questions: 
               actual-data-nodes: ds1.questions_$->{1..2}
               key-generate-strategy:
                 column: id
                 key-generator-name: snowflake
               table-strategy:
                 standard:
                   sharding-algorithm-name: tbstrategy
                   sharding-column: id
   
   


-- 
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: notifications-unsubscribe@shardingsphere.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org