Quote:
Originally Posted by fozzy71
I will let dave or juk answer the vac/analyze questions. I am an SQL-tard.
I'm a bit of an SQL-tard too I'm affraid.
Quote:
Originally Posted by a nonymous
What does a vacuum analyze in HEM do? Improves performance, right?
AFAIK, vacumm reclaims wasted space occupided by stuff you've deleted and analyze makes future queries run more efficiently.
Quote:
How often do I do it? Is there any downside to doing it/any reason to not do it every day?
You prolly won't gain much by doing it too often, but if you never do it then performance will start to slowly degrade. Doing it once every couple of weeks is prolly enough (or after importing a huge amount of data such as with bought data-mined hands, etc).
Juk