PDA

View Full Version : Hand histories won't display in the lower half of reports



discobisco
08-12-2009, 03:33 PM
In the lower part of the reports or any tab (hands, sessions, etc) my hand histories wont display at all. Whether i click last 100, last 500, or all, nothing displays. I know i'm clicking on the appropriate limit in the top half and still nothing. I just vacuumed my database last night and since then it has been doing this. I tried updating to the new beta 23a version and still doesn't work.

discobisco
08-12-2009, 05:47 PM
its working now but only after sitting there waiting for about 10 minutes. for some reason it just takes a really long time to display my hh's and its not even for a big sample. i tried it for only 1400 hand sample and it takes 10 minutes of sitting there thinking before it displays my hh's

fozzy71
08-12-2009, 06:51 PM
From a very similar thread: http://www.holdemmanager.net/forum/showthread.php?p=69196


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:

- Turning off logging and deleting existing logs
- Vacuum/Full/Analyze, then Reindex
- SQL Tuning Wizard
- 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



Awesome fozzy, ty. HEM is running better than ever!

discobisco
08-12-2009, 09:56 PM
hey fozzy, thanks...i basically just removed some of the last few columns from the hand view and now it works fine again.

fozzy71
08-13-2009, 12:43 AM
Yep, that is a big CPU and DB load to display that info (in large samples, especially). I usually keep my HM set to something like This Month, or Today, instead of All Hands so it is faster switching between tabs. I don't have a need to see my lifetime stats all the time. I am usually more interested in the short term. :(