Page 1 of 1

POker Tracker 2 takes FOREVER to bring up stats

PostPosted: Fri Mar 06, 2009 5:01 pm
by ab1183
When I attempt to bring up tournament player stats it gets to "Retreiving Blind Summary" or something similar and then stops working. I leave it open for hours, and it never works. I recently had to convert my DB to SQL due to its size. What should I do?

Re: POker Tracker 2 takes FOREVER to bring up stats

PostPosted: Fri Mar 06, 2009 9:15 pm
by ptrack pat
Use the Utilities > PostgreSQL Database Functions window to do a FULL vacuum/analyze on the database. Also, if you don't have any filters set on the preferences tab of the stats window then it's probably trying to retrieve the entire database. You should use some date filters (like since a date) so it's only trying to retrieve a subset of the data when the window first opens.

highfalutin