Re: [sqlite] Insert large data question ??

2010-05-12 Thread Black, Michael (IS)
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

[sqlite] Insert large data question ??

2010-05-11 Thread 風箏
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

Re: [sqlite] Insert large data question ??

2010-05-11 Thread Richard Hipp
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

Re: [sqlite] Insert large data question ??

2010-05-11 Thread Lei, Rick (GE EntSol, SensInsp)
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 ??

2010-05-11 Thread P Kishor
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

Re: [sqlite] Insert large data question ??

2010-05-11 Thread 風箏
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

Re: [sqlite] Insert large data question ??

2010-05-11 Thread Marcus Grimm
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