<div dir="ltr">Simple Reports results run slow. The average is about 20 to 30 min here.</div><br><div class="gmail_quote"><div dir="ltr" class="gmail_attr">On Thu, Jun 8, 2023 at 2:09 PM John Amundson via Evergreen-reports <<a href="mailto:evergreen-reports@list.evergreen-ils.org">evergreen-reports@list.evergreen-ils.org</a>> wrote:<br></div><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex"><div dir="ltr"><div class="gmail_default" style="font-family:arial,helvetica,sans-serif;font-size:small;color:rgb(0,0,0)">Hello!</div><div class="gmail_default" style="font-family:arial,helvetica,sans-serif;font-size:small;color:rgb(0,0,0)"><br></div><div class="gmail_default" style="font-family:arial,helvetica,sans-serif;font-size:small;color:rgb(0,0,0)">Is anyone out there using the new Simple Reporter available in (I think) Evergreen 3.9+?</div><div class="gmail_default" style="font-family:arial,helvetica,sans-serif;font-size:small;color:rgb(0,0,0)"><br></div><div class="gmail_default" style="font-family:arial,helvetica,sans-serif;font-size:small;color:rgb(0,0,0)">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.</div><div class="gmail_default" style="font-family:arial,helvetica,sans-serif;font-size:small;color:rgb(0,0,0)"><br></div><div class="gmail_default" style="font-family:arial,helvetica,sans-serif;font-size:small;color:rgb(0,0,0)">As an example, this straightforward query brings back circ counts for one of our library for one month:</div><div class="gmail_default" style="font-family:arial,helvetica,sans-serif;font-size:small;color:rgb(0,0,0)"><br></div><div class="gmail_default" style="font-family:arial,helvetica,sans-serif;font-size:small;color:rgb(0,0,0)">SELECT <a href="http://ou.name" target="_blank">ou.name</a>, count(distinct <a href="http://circ.id" target="_blank">circ.id</a>) as circs<br>FROM actor.org_unit ou<br>    JOIN action.all_circulation circ ON circ.circ_lib=<a href="http://ou.id" target="_blank">ou.id</a><br>WHERE <a href="http://ou.id" target="_blank">ou.id</a>=65 AND circ.xact_start::DATE between '2022-01-01' and '2022-01-31'<br>GROUP BY 1<br></div><div class="gmail_default" style="font-family:arial,helvetica,sans-serif;font-size:small;color:rgb(0,0,0)"><br></div><div class="gmail_default" style="font-family:arial,helvetica,sans-serif;font-size:small;color:rgb(0,0,0)">It runs in about a minute directly on the database.<br></div><div class="gmail_default" style="font-family:arial,helvetica,sans-serif;font-size:small;color:rgb(0,0,0)"><br></div><div class="gmail_default" style="font-family:arial,helvetica,sans-serif;font-size:small;color:rgb(0,0,0)">Recreating it in the traditional reporter, it also runs in 1 to 2 minutes.</div><div class="gmail_default" style="font-family:arial,helvetica,sans-serif;font-size:small;color:rgb(0,0,0)"><br></div><div class="gmail_default" style="font-family:arial,helvetica,sans-serif;font-size:small;color:rgb(0,0,0)">However, if I try to create it in the Simple Reporter, it takes almost <b><i>40 minutes</i></b>! </div><div class="gmail_default" style="font-family:arial,helvetica,sans-serif;font-size:small;color:rgb(0,0,0)"><br></div><div class="gmail_default" style="font-family:arial,helvetica,sans-serif;font-size:small;color:rgb(0,0,0)">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.</div><div class="gmail_default" style="font-family:arial,helvetica,sans-serif;font-size:small;color:rgb(0,0,0)"><br></div><div class="gmail_default" style="font-family:arial,helvetica,sans-serif;font-size:small;color:rgb(0,0,0)">Is anyone else having this issue? Any insight to share?<br></div><div class="gmail_default" style="font-family:arial,helvetica,sans-serif;font-size:small;color:rgb(0,0,0)"><br></div><div class="gmail_default" style="font-family:arial,helvetica,sans-serif;font-size:small;color:rgb(0,0,0)">Thanks!</div><div class="gmail_default" style="font-family:arial,helvetica,sans-serif;font-size:small;color:rgb(0,0,0)"><br></div><div class="gmail_default" style="font-family:arial,helvetica,sans-serif;font-size:small;color:rgb(0,0,0)">John</div><div class="gmail_default" style="font-family:arial,helvetica,sans-serif;font-size:small;color:rgb(0,0,0)"><br></div><div class="gmail_default" style="font-family:arial,helvetica,sans-serif;font-size:small;color:rgb(0,0,0)"><br></div><div><div dir="ltr" class="gmail_signature"><div dir="ltr"><div><div dir="ltr"><div><div dir="ltr"><div><div dir="ltr"><div><div dir="ltr"><div><div dir="ltr"><div><div dir="ltr"><div><div dir="ltr"><div dir="ltr"><div dir="ltr"><div dir="ltr"><div dir="ltr"><table style="color:rgb(80,0,80);font-size:12.8px;border:none;border-collapse:collapse"><tbody><tr style="height:0pt"><td style="border-right:0.5pt solid rgb(0,0,0);vertical-align:top;padding:5pt"><p><img width="96" height="63" src="https://ci3.googleusercontent.com/mail-sig/AIorK4wvJisWKEcU1hp3aB6DvlIiGEoGe1GB9N5Bd_3T9VrHtqvFZ2MKH6Iyyzn0PTTeUWUJ5cCNNec"></p></td><td style="border-left:0.5pt solid rgb(0,0,0);vertical-align:top;padding:5pt"><p dir="ltr" style="line-height:1.9872;margin-top:0pt;margin-bottom:0pt"><span style="font-size:10pt;font-family:Verdana;color:rgb(0,0,0);background-color:transparent;vertical-align:baseline;white-space:pre-wrap">John Amundson | Library Applications Supervisor | CW MARS</span></p><p dir="ltr" style="line-height:1.9872;margin-top:0pt;margin-bottom:0pt"><span style="font-size:10pt;font-family:Verdana;vertical-align:baseline;white-space:pre-wrap;background-color:transparent"><font color="#000000"><a href="mailto:jamundson@cwmars.org" target="_blank">jamundson@cwmars.org</a> | <a href="tel:%28508%29%20755-3323" target="_blank">508-755-3323 x322</a></font></span></p><p dir="ltr" style="line-height:1.9872;margin-top:0pt;margin-bottom:0pt"><span style="font-size:10pt;font-family:Verdana;vertical-align:baseline;white-space:pre-wrap;background-color:transparent"><font color="#000000"><a href="https://www.cwmars.org/" target="_blank">https://www.cwmars.org</a></font></span></p><p dir="ltr" style="line-height:1.9872;margin-top:0pt;margin-bottom:0pt"><span style="font-size:10pt;font-family:Verdana;vertical-align:baseline;white-space:pre-wrap;background-color:transparent"><a href="https://www.mypronouns.org/he-him" target="_blank">he/him/his</a></span></p></td></tr></tbody></table></div></div></div></div></div></div></div></div></div></div></div></div></div></div><a href="http:///" target="_blank"></a></div></div></div></div></div></div></div></div>
_______________________________________________<br>
Evergreen-reports mailing list<br>
<a href="mailto:Evergreen-reports@list.evergreen-ils.org" target="_blank">Evergreen-reports@list.evergreen-ils.org</a><br>
<a href="http://list.evergreen-ils.org/cgi-bin/mailman/listinfo/evergreen-reports" rel="noreferrer" target="_blank">http://list.evergreen-ils.org/cgi-bin/mailman/listinfo/evergreen-reports</a><br>
</blockquote></div><br clear="all"><div><br></div><span class="gmail_signature_prefix">-- </span><br><div dir="ltr" class="gmail_signature"><div dir="ltr"><div dir="ltr"><div dir="ltr"><div dir="ltr"><div dir="ltr"><div style="border:0px;font-family:"Carrois Gothic",sans-serif;font-size:12.8px;margin:0px;outline:0px;padding:0px;vertical-align:baseline;color:rgb(38,38,38);line-height:24px">Tony Miller</div><div style="border:0px;font-family:"Carrois Gothic",sans-serif;font-size:12.8px;margin:0px;outline:0px;padding:0px;vertical-align:baseline;color:rgb(38,38,38);line-height:24px"><span style="color:rgb(0,0,0);font-family:Calibri;font-size:small;background-color:rgb(255,255,255)"><b>User Services Coordinator </b></span><br></div><div style="border:0px;margin:0px;outline:0px;padding:0px;vertical-align:baseline;line-height:24px"><div style="color:rgb(38,38,38);font-family:"Carrois Gothic",sans-serif;font-size:12.8px;border:0px;margin:0px;outline:0px;padding:0px;vertical-align:baseline"><div style="border:0px;font-size:12.8px;margin:0px;outline:0px;padding:0px;vertical-align:baseline"><div style="font-family:"Open Sans",sans-serif;font-size:18px;margin:0px;padding:0px;vertical-align:baseline;border:0px;outline:0px;color:rgb(68,67,64)"><div style="margin:0px;padding:0px;vertical-align:baseline;border:0px;outline:0px"><img src="https://pbmldstaff.files.wordpress.com/2022/03/01.png" alt="01" width="182" height="118" style="height: auto; max-width: 100%;"></div><div style="margin:0px;padding:0px;vertical-align:baseline;border:0px;outline:0px">318 North Main Street | Poplar Bluff, MO 63901<br>(573) 686 – 8639</div><div style="margin:0px;padding:0px;vertical-align:baseline;border:0px;outline:0px"><span style="font-weight:700"><a href="https://poplarbluff.org/" rel="noopener" style="font-family:inherit;font-weight:inherit;font-style:inherit;margin:0px;padding:0px;vertical-align:baseline;border:0px;outline:0px;color:rgb(21,182,184)" target="_blank">Website</a> | <a href="https://poplarbluff.org/OTS.pdf" rel="noopener" style="font-family:inherit;font-weight:inherit;font-style:inherit;margin:0px;padding:0px;vertical-align:baseline;border:0px;outline:0px;color:rgb(21,182,184)" target="_blank">Newsletter</a> | <a href="https://poplarbluff.org/annualreport.html" rel="noopener" style="font-family:inherit;font-weight:inherit;font-style:inherit;margin:0px;padding:0px;vertical-align:baseline;border:0px;outline:0px;color:rgb(21,182,184)" target="_blank">Annual Report</a> | </span><span style="font-weight:700"><a href="http://poplarbluff.org/downloads.html" rel="noopener" style="font-family:inherit;font-weight:inherit;font-style:inherit;margin:0px;padding:0px;vertical-align:baseline;border:0px;outline:0px;color:rgb(21,182,184)" target="_blank">Digital Library</a></span><span style="font-weight:700"> </span></div><div style="margin:0px;padding:0px;vertical-align:baseline;border:0px;outline:0px"> </div><div style="margin:0px;padding:0px;vertical-align:baseline;border:0px;outline:0px"><p style="font-family:inherit;font-weight:inherit;font-style:inherit;margin:0px 0px 1.6em;padding:0px;vertical-align:baseline;border:0px;outline:0px"><span style="font-weight:700"><i><span style="font-family:garamond,"times new roman",serif;font-size:large;font-weight:inherit;font-style:inherit;margin:0px;padding:0px;vertical-align:baseline;border:0px;outline:0px"><span style="font-family:inherit;font-size:18px;font-weight:inherit;font-style:inherit;margin:0px;padding:0px;vertical-align:baseline;border:0px;outline:0px">​</span></span></i></span><i style="font-size:revert;color:initial">​<span style="font-family:inherit;font-weight:700;font-style:inherit;margin:0px;padding:0px;vertical-align:baseline;border:0px;outline:0px">Promoting Libraries to Make Our Communities Stronger</span></i></p><div style="font-family:inherit;font-weight:inherit;font-style:inherit;margin:0px;padding:0px;vertical-align:baseline;border:0px;outline:0px"><div style="font-family:inherit;font-weight:inherit;font-style:inherit;margin:0px;padding:0px;vertical-align:baseline;border:0px;outline:0px">Poplar Bluff Municipal Library District with its community partners provides and promotes equal access to reading, information, cultural and intellectual resources.</div></div></div></div></div></div></div><div style="border:0px;font-family:"Carrois Gothic",sans-serif;font-size:12.8px;margin:0px;outline:0px;padding:0px;vertical-align:baseline;color:rgb(38,38,38);line-height:24px"></div></div></div></div></div></div></div>