In the description of the "Create Index" statement, it says: "Every time the database is opened, all CREATE INDEX statements are read from the sqlite_master table and used to regenerate SQLite's internal representation of the index layout."
Does this mean that all of the indices are regenerated when the database is opened, or is the index stored and this is just confirming the structure? I am reading the database from a web application, so generally each query reopens the database. If all the indices are being recalculated each time, I would probably be better off only creating them for those complex queries where they are likely to make a difference. If the indices are calculated once and then stored, I am better off adding more of them (especially on more static elements) since at this point file size is of lesser importance. Thanks for the clarification, Jon _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
