PDA

View Full Version : Optimize other players



Bruto
04-11-2009, 06:34 AM
Hello,

I'm trying to run reports over other players from datamined hands. It takes a lot of time with players with large number of hands (+10K).

There is some way to optimize other players to improve this querys??

Thanks.

morny
04-11-2009, 08:18 AM
See this thread http://www.holdemmanager.net/forum/showpost.php?p=27023&postcount=2 removing those columns can speed things up quite a bit, also see this thread

For forcing optimisation the secret is to import a hand where their hole cards were shown before the flop. HM recognizes they are a “hero” and does the optimization. There is a table in the database that you can use to force it



1) Open pgadmin and open the sql window for the database

2) Select * from players where playername = ‘ABC123’

3) Use the player_id from there and then, assuming the player_id = 12345

4) Insert into unoptimizedheros values (12345)