-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 On 02/12/2011 11:40 AM, Simon Slavin wrote: > Does it make the ANALYZE command take significantly longer ?
I don't think that matters. If someone runs ANALYZE it is because they are experiencing performance issues using default (non-analyzed) query planner heuristics. When they run ANALYZE they want SQLite to go faster using more information! If ANALYZE+stat2 takes a really long time then it could be extended to take parameter indicating how much analysis it does. eg "ANALYZE 1", "ANALYZE 2" with the default being the same as today. The feature I would love most in SQLite is a way of providing a query indicating it will be run a lot in the future and SQLite can do whatever it wants to then make it go faster, such as running ANALYZE, making indices etc. Roger -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.10 (GNU/Linux) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org/ iEYEARECAAYFAk1W5x4ACgkQmOOfHg372QTa2wCgn7gRC8F9CB3CasUT2fVfLYfi dF0An31PeT8mr6QX+oYU/aAq4dEuWhtc =UAce -----END PGP SIGNATURE----- _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
