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