HM2 caches certain information in order to optimize search results and report load times. The amount of caching (and thus the amount of RAM used) for an individual user is, in part, dependent on the RAM available and how much RAM is required for other applications you are running. Thus HM2 intelligently uses RAM based on a balancing act between how much you have and how much you are using elsewhere. If someone has a significant amount of RAM available, HM2 will cache more in order to further improve your response times to queries and report loading.
HM2 load time is slower than HM1 and our competitors because we cache hands into memory on startup to take advantage of your PC resources. This allows us to populate reports and run filters way faster than HM1 or our competitors. This extra time at start up saves you a lot more time when you start refreshing/changing reports and running filters to review your play.
See the following page for a comparison of HM2 v HM1 v PT4 on 3 different machines with 3 different sample sizes and you can see why this slower start up time that is done once per session or once per day will save you tons of time once you start reviewing your data -
HM2 Performance Comparison on v7679 With Ram Reduction vs PT4 and HM1
Regarding maintenance: You should run PGAdmin maintenance regularly. I would suggest at least once a month (or more if you play a lot of hands and/or use NoteCaddy), and any time you do a large import -
http://hm2faq.holdemmanager.com/ques...lyze+Database+