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