On 12 Apr 2016, at 2:56am, Jose I. Cabrera <jicman at yahoo.com> wrote:
> Maybe this should be something to think about, and perhaps add it as part of > the results or reported items of .schema. Also, only update the date if > completion successful. The reason why it's important is that I have a script > that runs every week, but lately, it appears as if it is failing, but the log > files say it is running. However, the searches are getting slower and slower. You should not need to run ANALYZE very often. Perhaps once a year. The only exceptions are when your database schema changes or if the entire nature of the data in it changes. If your searches are getting noticeably slower then you probably have poor indexes (or no indexes) on your tables. If you'd like to post your CREATE TABLE, CREATE INDEX and SELECT commands we might be able to help you. Simon.
