[Evergreen-reports] Speed issues with the Simple Reporter

[John Amundson]

Hello!

Is anyone out there using the new Simple Reporter available in (I think)
Evergreen 3.9+?

We are testing the interface in CW MARS in Evergreen 3.10 and are finding
its reports exceptionally slow to run, especially when involving
circulation data.

As an example, this straightforward query brings back circ counts for one
of our library for one month:

SELECT ou.name, count(distinct circ.id) as circs
FROM actor.org_unit ou
    JOIN action.all_circulation circ ON circ.circ_lib=ou.id
WHERE ou.id=65 AND circ.xact_start::DATE between '2022-01-01' and
'2022-01-31'
GROUP BY 1

It runs in about a minute directly on the database.

Recreating it in the traditional reporter, it also runs in 1 to 2 minutes.

However, if I try to create it in the Simple Reporter, it takes almost *40
minutes*!

I've tried to run slightly more complicated circ reports; some of them
don't run at all, and others take more than an hour, which makes the
function unusable for our network.

Is anyone else having this issue? Any insight to share?

Thanks!

John


John Amundson | Library Applications Supervisor | CW MARS

jamundson at cwmars.org | 508-755-3323 x322 <%28508%29%20755-3323>

https://www.cwmars.org

he/him/his <https://www.mypronouns.org/he-him>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://list.evergreen-ils.org/pipermail/evergreen-reports/attachments/20230608/2ce374f4/attachment.htm>