On 12/1/06, RB Smissaert <[EMAIL PROTECTED]> wrote:
Having a reasonably big SQLite database, 21 tables, one table with some millions of rows, overall file size about 1.3 Gb. This table will only get SELECT statements once it has been created. I have now run analyze on this file and it does speed queries up indeed. Do I run analyze after the table has been completed (all tables created and populated) or should I run analyze before the creation of any tables as I read somewhere?
Frankly, I don't know what ANALYZE exactly does, but I would think it would be after all the tables have been populated, so ANALYZE can make sure all the indexes are complete, and calculate whatever stats that SQLite might be depending on internally. That is how I do it. -- Puneet Kishor http://punkish.eidesis.org/ Nelson Inst. for Env. Studies, UW-Madison http://www.nelson.wisc.edu/ Open Source Geospatial Foundation https://edu.osgeo.org/ --------------------------------------------------------------------- collaborate, communicate, compete ===================================================================== ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------
