Re: "I can't see how you get to that page....."
I found the link from page:
http://www.sqlite.org/features.html
And perhaps it's linked from others as well.
Re: "I would expect to reorganise the physical database on a regular
basis..."
Once again, I'd look at the VACUUM command, though you may find you
don't really need to run it very often.
http://www.sqlite.org/lang_vacuum.html
You may also be interested in the ANALYZE command, which can provide
hints to sqlite's query optimizer.
http://www.sqlite.org/lang_analyze.html
Once you're up and running with your database app, running analyze just
once may be enough.
You might want to do some experiments to see if running either of these
frequently has a measurable benefit to your application.
Hope this helps,
Donald
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
