Sven L wrote: > I've discovered that the ANALYZE command is extremely slow on my > large databases. I read the documentation and it says that the > command should be issued when the schema is changed "a lot". Hmm, > when exactly could that be? Currently, I issue the command every time > I have inserted ~1000 rows in my main table.
My guess is that schema would change when you change the schema. Adding a 1000 rows, or even a billion rows, is not changing the schema. If all you are doing is adding the rows, your indexes will be updated automatically, so you are probably wasting time re-running ANALYZE. .. -- Puneet Kishor _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
