在DB2表中插入1毫升+记录的最快方式是什么? [英] What is the fastest way to insert 1 mln+ records in DB2 table?
问题描述
在C#中,我有1mln +记录是插入DB2表所必需的。
在DB2表中插入1 mln +记录的最快方式是什么?我已经检查了几种方法,最快的是基于以下请求的1000行:
INSERT INTO tbl(id,rel)值(1, 2),(2,3),...
是否有其他想法?
尝试一下这样的1000条记录:
INSERT INTO表
SELECT
cast(RAND()* 50000 as numeric(6))AS id,
cast(RAND()as varchar(30))AS rel,
FROM qsys2 / COLUMNS
fetch前1000行只有
更改表
和字段性质/与您相关的长度表。
我假设
cast(RAND()* 50000 as numeric(6))AS id
id
是数字6字节
最后一行你限制1000行insert
In C# I have 1mln+ records which are necessary to insert into DB2 table. What is the fastest way to insert 1 mln+ records in DB2 table?
I've check several way and the fastest is by 1000 rows basing on the following request: INSERT INTO tbl (id, rel) values (1, 2), (2,3),...
Are the any other ideas?
Try wth something like that for 1000 records:
INSERT INTO table
SELECT
cast (RAND()*50000 as numeric(6)) AS id,
cast (RAND() as varchar(30)) AS rel,
FROM qsys2/COLUMNS
fetch first 1000 rows only
change table
and the field nature/length in relation with you table.
I assumed with that
cast (RAND()*50000 as numeric(6)) AS id
that id
is numeric 6 byte
with the last line you limit 1000 rows insert
这篇关于在DB2表中插入1毫升+记录的最快方式是什么?的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!