Thanks Oliver that is what I am doing at the moment. I was wondering whether there might be a quicker way maybe using temporary tables for similar - just exploring ideas
On Tuesday, August 3, 2010, Oliver Peters <oliver....@web.de> wrote: > Am Dienstag, den 03.08.2010, 23:24 +0100 schrieb Paul Sanderson: > > [...] > >> I the process to be as quiick as >> possible (although I know it will take minutes). The process at the >> moment is to drop the indexes, add the new rows and then reindex. >> >> Is this the best/fastest way of achieving this - is there a faster way? > > [...] > > BEGIN TRANSACTION; > > INSERT INTO table(a,b,c) VALUES(1,2,3); > > --more INSERTS > > COMMIT; > > > Oliver > > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > -- Paul Sanderson Sanderson Forensics +44 (0)1869 325667 www.sandersonforensics.com http://www.twitter.com/sandersonforens _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users