You haven't said what kind of machine you're running on.
I did this test using 9,000,000 records and got 40,000 inserts per second.
sqlite3 test.db :
> On Tue, May 11, 2010 at 12:47 AM, ?? wrote:
>> Dear
>>
>> I have about 9 million data insert string need to insert into an table ,each
>> row
> 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
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/1
On Tue, May 11, 2010 at 12:47 AM, 風箏 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 is my
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
Does the following document help?
http://www.sqlite.org/faq.html#q19
On Tue, May 11, 2010 at 1:47 AM, 風箏 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,000
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 VA
7 matches
Mail list logo