Re: [sqlite] SQLite Release 3.18.0

On 4/2/17, David Burgess wrote: > I tried optimize. > sqlite> pragma main.optimize; > Error: database schema has changed > I think that means you ran "PRAGMA optimize" as the very first command on a freshly opened database connection. This should be a no-op. Read the go-bys - you should run "PRA

Re: [sqlite] SQLite Release 3.18.0

I am getting the same thing with just plain, PRAGMA optimize; -Original Message- From: David Burgess Sent: Sunday, April 2, 2017 9:56 PM To: SQLite mailing list Subject: Re: [sqlite] SQLite Release 3.18.0 I tried optimize. sqlite> pragma main.optimize; Error: database schema

Re: [sqlite] SQLite Release 3.18.0

I tried optimize. sqlite> pragma main.optimize; Error: database schema has changed sqlite> pragma temp.optimize; sqlite> Anyone know what the error message means? On Mon, Apr 3, 2017 at 11:42 AM, jose isaias cabrera wrote: > > Thanks, Dr. Hipp for the new release of SQLite v3.18.0. One of bull

[sqlite] SQLite Release 3.18.0

Thanks, Dr. Hipp for the new release of SQLite v3.18.0. One of bullets of the new Added the PRAGMA optimize command is, (Not yet implemented) Create indexes that might have been helpful to recent queries. May I also suggest that the tool also provides info on useless indexes. Thanks. josé