Page 1 of 1

Report takes SUPERLONG to load

PostPosted: Tue Sep 17, 2013 8:20 pm
by jacktheshipper
so long that at this point im not even sure if it will ever load. Ive waited around maybe 2 hours already. I have around 500K hands in my database however, and all are requested by this report, is this normal? any way to speed it up?

I have an SSD with pt4 on it and top of the line pc, really hope theres a fix.

Re: Report takes SUPERLONG to load

PostPosted: Wed Sep 18, 2013 9:16 am
by kraada
Which report are you trying to load?

Re: Report takes SUPERLONG to load

PostPosted: Wed Sep 18, 2013 6:52 pm
by jacktheshipper
the husng one i found in the download warehouse, will update with screenshot in a few minutes

Re: Report takes SUPERLONG to load

PostPosted: Wed Sep 18, 2013 7:21 pm
by jacktheshipper
http://i.imgur.com/uh4vsWn.png

Ive also noticed now that the hour stat is wrong, as well as the $/hr (although that probably flows out of the fact that the hours played stat is just wrong) So if possible id like to fix this too :O

This didnt take too long, but its only "this month", Ive also been playing very little poker compared to lets say 6 months ago lately so yeah :P

Re: Report takes SUPERLONG to load

PostPosted: Thu Sep 19, 2013 2:31 am
by WhiteRider
Can you tell us the exact name of the report so that we can check it out?

Adding custom stats to a report can make it take significantly longer depending on what information the stat is retrieving as custom stats aren't cached.

Re: Report takes SUPERLONG to load

PostPosted: Thu Sep 19, 2013 3:17 pm
by jacktheshipper
HUSNG summary by FabioTheDoc Aug. 03, 2012
82 downloads

Report indicated for HUSNG players.

This report, which creates a row for each day played, lists: date, number of tournaments played, percentage of winnings (ITM%), total buy-in, average buy-in, total rake paid, ROI%, ROI% adjusted and $/h rate.


found it here : https://www.pokertracker.com/custom/reports

Re: Report takes SUPERLONG to load

PostPosted: Sun Sep 29, 2013 6:48 am
by jacktheshipper
any fix?

Re: Report takes SUPERLONG to load

PostPosted: Sun Sep 29, 2013 9:03 am
by WhiteRider
Apologies - I haven't had chance to look at that report in detail yet, but I do have it on my list. I'll try to get to it in the next couple of days.

Re: Report takes SUPERLONG to load

PostPosted: Mon Sep 30, 2013 11:52 am
by WhiteRider
The problem is caused by the final stat in the report - it is using the wrong "My C per hour" stat. There are different "per hour" stats to match the grouping of a report, and because this report groups stats by date it needs to use the stat "My Currency Net Won Per Hour Date" (instead of "... Month"). Remove the last stat in the report and it should work fine - you can replace it with the "...Date" version if you want to see that too.
I will get the stat in the Warehouse updated too - thanks for letting us know about this.

highfalutin