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 command to insert to table
sqlite3 MyDB < insertTables
For compeleting to insert 1 million rows it may take up to a day. Is there any 
way to speech up the insertion in this case.
Thanks,
JL


      
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Reply via email to