I've noticed recently that Adjust Limits is very slow to populate the players list. It will take 5-10 minutes. There are indeed some 300k players in the db, but still.
The query below appears to be the one that takes time. I tried running it in pgadmin, and it completes in seconds.
Normal behaviour, known issue or something that needs to be reported?
I'm also seeing similar slow performance in the Purge dialog. Sometimes I also see corrupted player/session lists, where clicking on a particular player doesn't give sessions for that player. And all players don't appear to be in the list. PT3 version is 3.13.9
- Code: Select all
2012/08/07 14:43:26.519: [00000EA0][Query::QueryThread] Thread [0x00000EA0]: Begin
2012/08/07 14:43:26.532: [00000EA0][Query] Connecting to database: PokerTracker 3 Database
2012/08/07 14:43:26.533: [00000EA0][Query] Executing SQL (Thread): SELECT id_player, id_site, player_name, val_icon FROM player WHERE id_player > 0 AND id_player_alias = 0 AND id_player <> 0 ORDER BY player_name_search asc
2012/08/07 14:43:27.313: [00000EA0][Query] Query execution time: 779.43314682 ms
2012/08/07 14:43:27.339: [00000EA0][QueryReportCtrl::Populate] Thread [0x00000EA0]: Begin
2012/08/07 14:44:13.320: [00000EA0][QueryReportCtrl] Query 6: Populate: 45980.3860 ms, 336476 rows, 6 cols, 0.0228 ms/col (time log: Query 6: t0: 0.2949 ms, t1: 596.5985 ms, t2: 45383.4090 ms, t3: 0.0044 ms, t4: 0.0044 ms, t5: 0.0116 ms, t6: 0.0068 ms)
