Am Dienstag, den 03.08.2010, 23:24 +0100 schrieb Paul Sanderson: [...]
> I want 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
