On 21 Jul 2011, at 2:28pm, Alok Singh wrote: > I am trying to Insert values into New Table "Ticket" from > Table1,Table2,Table3 and Table4 with the following Query but its taking alot > of time to insert values in new table. > VB.NET + SQLITE using ADO.net connection (
Before your for INSERT command execute the SQL command "BEGIN TRANSACTION" After your last INSERT command execute the SQL command "COMMIT" Simon. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users