[Evergreen-reports] Speed issues with the Simple Reporter

[Tony Miller]

Simple Reports results run slow. The average is about 20 to 30 min here.

On Thu, Jun 8, 2023 at 2:09 PM John Amundson via Evergreen-reports <
evergreen-reports at list.evergreen-ils.org> wrote:

> 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>
> _______________________________________________
> Evergreen-reports mailing list
> Evergreen-reports at list.evergreen-ils.org
> http://list.evergreen-ils.org/cgi-bin/mailman/listinfo/evergreen-reports
>


-- 
Tony Miller
*User Services Coordinator *
[image: 01]
318 North Main Street | Poplar Bluff, MO 63901
(573) 686 – 8639
Website <https://poplarbluff.org/> | Newsletter
<https://poplarbluff.org/OTS.pdf> | Annual Report
<https://poplarbluff.org/annualreport.html> | Digital Library
<http://poplarbluff.org/downloads.html>


*​**​Promoting Libraries to Make Our Communities Stronger*
Poplar Bluff Municipal Library District with its community partners
provides and promotes equal access to reading, information, cultural and
intellectual resources.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://list.evergreen-ils.org/pipermail/evergreen-reports/attachments/20230608/45eedcee/attachment-0001.htm>