On 11 Aug 2014, at 5:19pm, Drago, William @ MWG - NARDAEAST <william.dr...@l-3com.com> wrote:
> Does it matter if I group all of my CREATE INDEX statements at the end of my > .sql file or should they appear right after each CREATE TABLE statement? Does > SQLITE care one way or another? The results are identical. But if you have lots of INSERTs in the same .sql file, it's faster to insert the data first and then create the indexes. And don't forget to put your INSERTs inside transactions. Simon. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
