Hi I have a table that contains 6 columns of integers, 2 of these columns are indexed. There are about 10 Million rows of data in the table. every now and again I need to add more rows, between about a thousand and a million at a time. 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? P _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
