On Thu, Dec 11, 2014 at 10:58 AM, Paul <de...@ukr.net> wrote:

>
> I have yet to try and test if dropping stat tables worth the effort.
>

Most of the work is involved in loading sqlite_stat4.  On the other hand,
most of the benefit comes from sqlite_stat1.  So consider compiling without
SQLITE_ENABLE_STAT4.  You will still probably get good query plans, but the
startup time should be reduced.


-- 
D. Richard Hipp
d...@sqlite.org
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Reply via email to