Re: [sqlite] Insert mil.rows to table can take up to a day

2008-07-01 Thread Mihai Limbasan
Joanne Pham wrote: > Thank you so much Mihai. > It worked!!! Once again thanks a ton. > JL > Glad to hear that - have fun! Mihai ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Insert mil.rows to table can take up to a day

2008-07-01 Thread Joanne Pham
Thank you so much Mihai. It worked!!! Once again thanks a ton. JL - Original Message From: Mihai Limbasan <[EMAIL PROTECTED]> To: General Discussion of SQLite Database Sent: Tuesday, July 1, 2008 10:57:31 AM Subject: Re: [sqlite] Insert mil.rows to table can take up to a day

Re: [sqlite] Insert mil.rows to table can take up to a day

2008-07-01 Thread Joanne Pham
Thanks a lot Mihai, I will try it. Again thank for quick response. JL - Original Message From: Mihai Limbasan <[EMAIL PROTECTED]> To: General Discussion of SQLite Database Sent: Tuesday, July 1, 2008 10:57:31 AM Subject: Re: [sqlite] Insert mil.rows to table can take up to

Re: [sqlite] Insert mil.rows to table can take up to a day

2008-07-01 Thread Mihai Limbasan
Joanne Pham wrote: > Hi All, > I have the file which has million rows of insert statement to insert the data > to the database like below: > insert into tables values(...) > > (there are million insert statement to insert to the table) > (file name is insertTa

[sqlite] Insert mil.rows to table can take up to a day

2008-07-01 Thread Joanne Pham
Hi All, I have the file which has million rows of insert statement to insert the data to the database like below:  insert into tables values(...) (there are million insert statement to insert to the table) (file name is insertTables) Then I ran the following co