PDA

View Full Version : Stats under the Reports tabs not displaying anything.



Eclipse86
10-12-2009, 12:26 PM
Just installed a fresh copy of HEM on a new computer.

Imported about 25-30 million hands into the DB and full vacuum/analyzed.

Now when I go into the reports tab and try to display stats on the different players, none of the stats will display (using date filter selection of After so and so month). However if I choose to display stats with the filter "Just this month" it will load.

On my old computer which uses a weaker processor with lower ram, is able to display these stats quite fast. So there must be something wrong, any suggestions?

On my old computer I can display stats on people I have 500k hands on in a couple minutes (displaying "All Hands'). However on the new install, it's still loading after 20 minutes for people which I have 250k hands on.

fozzy71
10-12-2009, 12:37 PM
That is a huge DB. :eek:

I would suggest you do the majority of the things in this thread: http://www.holdemmanager.net/forum/showthread.php?t=11194

Some of the most important things, imo:

- Remove the WinnerName, WinnerCards and WinnerWon from the Hands View Column Selector
- Turning off logging and deleting existing logs
- Vacuum/Full/Analyze, then Reindex - http://www.holdemmanager.net/faq/afmviewfaq.aspx?faqid=163
- Defrag last and make sure you stop the postgresql service before you defrag. I personally use Defraggler.
- Do a Cold Boot (Shut Down > Start) before you use HM again