PDA

View Full Version : Listing hands suddenly takes longer



Cervus
08-03-2010, 08:29 PM
For no obvious reason, it now takes quite a while for HEM to display hands (be it Reports or Hands view). Everything else is displayed instantly as before, but to list hands takes ~10 seconds, which is considerably longer than it used to be.

What gives? Is there anything I can try to get things back to normal?

_Loki_
08-03-2010, 08:56 PM
###
Update HM

Windows updates

Remove the WinnerName, WinnerCards and WinnerWon from the Hands View Column Selector (this helps a lot)
>> FAQ - Hold'em Manager Poker Tracking Software :: Hands View Column Selection (http://faq.holdemmanager.com/questions/192/Hands+View+Column+Selection)

Vacuum/Analyse Full your DB
>> FAQ - Hold'em Manager Poker Tracking Software :: Vacuum Analyze Database (http://faq.holdemmanager.com/questions/88/Vacuum+Analyze+Database+)

Reindex (same FAQ as above, but at step 6. click the reindex radio button)

Defrag with the postgreSQL service stopped (Start > programs > postgresql > stop server)

Reboot

###
>> FAQ - Hold'em Manager Poker Tracking Software :: Holdem Manager Performance & Speed Tweaks (http://faq.holdemmanager.com/questions/373/Holdem+Manager+Performance+%26+Speed+Tweaks)

###

Cervus
08-04-2010, 02:12 AM
Thanks for the tips, Loki. I've removed the unnecessary columns (I'd done it before, but for whatever reason there were back) and may try vacuuming the DB as well.

The thing is that it takes about a second for hands to be listed in the Reports view, but a minute or so when I switch to the Hands view. Any ideas why the time would be different?

netsrak
08-04-2010, 06:08 AM
Please try the vacuum and the performance things and report back if it doesn't help.

How many hands do you have in your database?
FAQ - Hold'em Manager Poker Tracking Software :: Check Total Amount of Hands in Database (http://faq.holdemmanager.com/questions/115/Check+Total+Amount+of+Hands+in+Database+)

_Loki_
08-04-2010, 08:13 PM
###

Thanks for the tips, Loki. I've removed the unnecessary columns (I'd done it before, but for whatever reason there were back) and may try vacuuming the DB as well.

The thing is that it takes about a second for hands to be listed in the Reports view, but a minute or so when I switch to the Hands view. Any ideas why the time would be different?

My guess...
partly because they use different sets of queries back to the DB
partly because of stuff Karsten & I have posted

###

Cervus
08-04-2010, 08:37 PM
My guess...
partly because they use different sets of queries back to the DB
partly because of stuff Karsten & I have posted
Why wouldn't they both use the query which works faster? :-)

Anyway, vacuuming seems to have helped. Thanks again.