Stop

[mousebreaker]

Hi
I have several hundred of thousands hands in my database. Sometimes I make a mistake when I want to create some filters. I run it on all hands instead of e.g a month, and HEM is taking very long time to come with the result, because I have so many hands.

My Q is: Are there a way to stop HEM when it is "thinking" ? ( a stop button would be great )

br
mouse

[fozzy71]

To help it retrieve results faster 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 Options > 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 Smart Defrag.
- Do a Cold Boot (Shut Down > Start) before you use HM again


Also, if you set the date filter to something like This Year, instead of All Hands, it will probably be quicker too. Then when needed you can change back to All Hands.