On 7 Feb 2011, at 4:38pm, Sven L wrote: > So, with this in mind, it makes sense to precompute the sqlite_stat* tables. > Right?
Which you do by running ANALYZE, but since it needs real-life data to work on there's no point doing it until your customer has put some data in. I don't write this type of application any more, but I might put it in a maintenance routine -- some obscure menu option near the Config Preferences or something. Run it as part of your yearly maintenance procedure, after you've run 'PRAGMA integrity_check'. Simon. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
