On Fri, Oct 14, 2011 at 12:46 PM, Fabian <fabianpi...@gmail.com> wrote:
> 2011/10/14 Simon Slavin <slav...@bigfraud.org>
> >
> > 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
> sqlite-users@sqlite.org
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
>
--
D. Richard Hipp
d...@sqlite.org
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
