To: General Discussion of SQLite Database
Subject: Re: [sqlite] Insert large data question ??
Thanks Kishor ,I will note it !!
I already used transaction to doing this job.
I tried to remove all of index ,this time the job used about 31600 seconds
ps. I had use PRAGMA synchronous=OFF in front
Dear
I have about 9 million data insert string need to insert into an table ,each
row data is unique
this is a sample:
insert into mydata
VALUES(38824801,56888,'AABBCC',4.999,157,'2009/9/10
19:55:50');
this is my schema:
table|mydata|mydata|2|CREATE TABLE mydata
(
itno
Does the following document help?
http://www.sqlite.org/faq.html#q19
On Tue, May 11, 2010 at 1:47 AM, 風箏 ler...@gmail.com wrote:
Dear
I have about 9 million data insert string need to insert into an table
,each
row data is unique
this is a sample:
insert into mydata
Try to use transaction syntax.
Rick
-Original Message-
From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org]
On Behalf Of �L�~
Sent: Tuesday, May 11, 2010 1:48 PM
To: sqlite-users@sqlite.org
Subject: [sqlite] Insert large data question ??
Dear
I have about 9
On Tue, May 11, 2010 at 12:47 AM, 風箏 ler...@gmail.com wrote:
Dear
I have about 9 million data insert string need to insert into an table ,each
row data is unique
this is a sample:
insert into mydata
VALUES(38824801,56888,'AABBCC',4.999,157,'2009/9/10
19:55:50');
this
Thanks Kishor ,I will note it !!
I already used transaction to doing this job.
I tried to remove all of index ,this time the job used about 31600 seconds
ps. I had use PRAGMA synchronous=OFF in front of my transaction.
someone can help me do this job more faster ??
thank everybody
2010/5/11
Thanks Kishor ,I will note it !!
I already used transaction to doing this job.
I tried to remove all of index ,this time the job used about 31600 seconds
ps. I had use PRAGMA synchronous=OFF in front of my transaction.
someone can help me do this job more faster ??
have you tried