Re: [sqlite] Insert large data question ??

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

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 of my transaction. > > someone can help me do this job more faster ?? have you

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 of my transaction. someone can help me do this job more faster ?? thank everybody

Re: [sqlite] Insert large data question ??

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 >

Re: [sqlite] Insert large data question ??

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

Re: [sqlite] Insert large data question ??

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 >

[sqlite] Insert large data question ??

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