> And also the output of running sqlite3_analyzer on your database Have run that now and the output looks impressive, although I have no idea yet how to use it. Output file is 72 Kb. Shall I send it as an attachement to this user-group?
RBS -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: 01 December 2006 21:01 To: sqlite-users@sqlite.org Subject: Re: [sqlite] When to run analyze? "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? > BTW, I would be interested in seeing the output of SELECT * FROM sqlite_stat1; After you have run analyze. And also the output of running sqlite3_analyzer on your database, if you are willing to share it. This kind of data helps me to see what people are putting into SQLite database, which in turn helps me to tune it better. -- D. Richard Hipp <[EMAIL PROTECTED]> ---------------------------------------------------------------------------- - To unsubscribe, send email to [EMAIL PROTECTED] ---------------------------------------------------------------------------- - ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------