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)
Powered by vBulletin® Version 4.2.3 Copyright © 2024 vBulletin Solutions, Inc. All rights reserved.