On Fri, Oct 14, 2011 at 12:46 PM, Fabian <[email protected]> wrote:
> 2011/10/14 Simon Slavin <[email protected]> > > > > So, OP, try issuing these commands > > > > DROP TABLE sqlite_stat1; > > DROP TABLE sqlite_stat2; > > > > then see whether anything improves. > > > > > I already tried that, but it returned: > > Error: table sqlite_stat1 may not be dropped > If you build from the Fossil trunk, DROP TABLE sqite_statN will work. Or, you can do this: DELETE FROM sqlite_stat1; DELETE FROM sqlite_stat2; ANALYZE sqlite_master; The extra ANALYZE is necessary to cause SQLite to reload the tables. Or, instead of doing the extra ANALYZE, you can close and reopen the database connection. > _______________________________________________ > sqlite-users mailing list > [email protected] > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > -- D. Richard Hipp [email protected] _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
