Report Improvements by Xon 2.20.6

[Brettflan]

Can you check how many open reports and unapproved items you have?

select count(*) from xf_report where report_state in ('open', 'assigned');
select count(*) from xf_approval_queue;

How XF maintains a count of those is kinda janky and requires loading all the items links to those and it doesn't scale at all.

Open/Assigned report count: 10
Approval Queue count: 0
Not too many. And to be clear, the list of reports loads quickly and has no apparent problems. It's when viewing an individual report that it seems to eat up a ton of memory and either run out of memory (with original 128MB or even 256MB PHP memory limit), or with >= 512MB PHP memory limit instead takes maybe 1-2 seconds to load those pages.

 

[Xon]

OK, something is really wrong it if it taking seconds to load.

I'ld recommend enabling debug mode and then viewing the page with ?_debug=1 to get a report for what SQL queries are taking time. Can you open a ticket on my site with this information?

 

[Brettflan]

OK, something is really wrong it if it taking seconds to load.

I'ld recommend enabling debug mode and then viewing the page with ?_debug=1 to get a report for what SQL queries are taking time. Can you open a ticket on my site with this information?

Will do.