On 4/2/17, David Burgess <[email protected]> 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 "PRAGMA optimize" after running many queries. I will fix the harmless warning in the next release. -- D. Richard Hipp [email protected] _______________________________________________ sqlite-users mailing list [email protected] http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
