--- RB Smissaert <[EMAIL PROTECTED]> wrote: > Could somebody explain to me why a particular table analyze is taking so > long? This is a large table, but still it seems the time to analyze this > table is out of proportion. ... > The table with the long analyze is the table ENTRY and this has indeed a few > million rows, but the table AUTHORISATION has a bit less than 1 million rows > and the analyze there is proportionally much faster. > Are these times just normal and is this just how it is or is there something > that I should be aware of? > Thanks for any advice.
If I'm not mistaken, I recall the SQLite documentation saying that ANALYZE only scans the indexes, not the table rows. Perhaps you have more indexes on that particular table. ____________________________________________________________________________________ Do you Yahoo!? Everyone is raving about the all-new Yahoo! Mail beta. http://new.mail.yahoo.com ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------
