All, I'm using the windows shell and I have to import one table from 50.000 small sqlite files into one big sqlite file.
These are the 2 options I see: 1 - Open the BIG db, attach all small files, ten by 10, and copy the tables from the attached databases to the big table. I can speed up the import by putting the INSERT in a transaction. 2 - Export one by one the table from all databases to a CSV file; import all CSV files into the BIG db; I don't have to worry about grouping the files by 10, but I cannot use transaction. What would be the best way to do this? One of these 2 ways, or is there a third way to do this? thanks gert _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
