On 25/07/2009 2:14 AM, Jon Dixon wrote: > 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 [snip]
It doesn't say "regenerate the index". It says "regenerate SQLite's internal representation of the index layout". It does what it says. Consider that building an index can take some considerable time ... it's not the sort of thing that the average customer wants to wait for at the start of the working day or when they turn the phone on to dial 112 or whatever -- especially when it's a rather pointless activity. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
