POker Tracker 2 takes FOREVER to bring up stats

[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?

[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.