On Fri, 22 Aug 2014 19:14:02 +0200 "Mario M. Westphal" <m...@mwlabs.de> wrote:
> Thanks, Richard > > > > After swapping back to the latest SQLite version and running an > Analyze on the sample databases, performance is up to the same level > as before (maybe even a bit faster). Very good. > > > > I will send out a recommendation to my users to run the weekly > diagnostics routine immediately to restore performance. Next time you can do it automatically. Set pragma user_version on db to your app version, and on open db check if it's current or not, and run analyze or make schema changes or whatever you want and update user_version. > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users --- --- Eduardo Morras <emorr...@yahoo.es> _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users