[sqlite] Last time analyze was ran

2016-04-12 Thread R Smith
On 2016/04/12 3:56 AM, Jose I. Cabrera 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

[sqlite] Last time analyze was ran

2016-04-12 Thread Simon Slavin
On 12 Apr 2016, at 2:56am, Jose I. Cabrera 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

[sqlite] Last time analyze was ran

2016-04-12 Thread Jay Kreibich
On Apr 12, 2016, at 2:38 AM, Simon Slavin wrote: > > On 12 Apr 2016, at 2:56am, Jose I. Cabrera 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.

[sqlite] Last time analyze was ran

2016-04-12 Thread Jose I. Cabrera
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

[sqlite] Last time analyze was ran

2016-04-11 Thread Simon Slavin
On 11 Apr 2016, at 8:32pm, Jose I. Cabrera wrote: > Just resending, as I didn't see a post for this one. Thanks. I don't think anyone can think of a way to do it. Therefore no responses. You could have your software make a note and store it in the database but SQLite doesn't note it

[sqlite] Last time analyze was ran

2016-04-11 Thread Jose I. Cabrera
Just resending, as I didn't see a post for this one. Thanks. On Monday, April 11, 2016 12:20 PM, Jose I. Cabrera wrote: Greetings! Is there a way to know when was the last time Analyze was ran on a database? My apologies if this was asked before, but I google a few searches to try to

[sqlite] Last time analyze was ran

2016-04-11 Thread Jose I. Cabrera
Greetings! Is there a way to know when was the last time Analyze was ran on a database? My apologies if this was asked before, but I google a few searches to try to find the answer, but there were none that showed anything regarding the question. So, I thought to ask the gurus. Thanks.