<div dir="ltr"><div class="gmail_default" style="font-family:arial,helvetica,sans-serif;font-size:small;color:#000000">Hello!</div><div class="gmail_default" style="font-family:arial,helvetica,sans-serif;font-size:small;color:#000000"><br></div><div class="gmail_default" style="font-family:arial,helvetica,sans-serif;font-size:small;color:#000000">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:#000000"><br></div><div class="gmail_default" style="font-family:arial,helvetica,sans-serif;font-size:small;color:#000000">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:#000000"><br></div><div class="gmail_default" style="font-family:arial,helvetica,sans-serif;font-size:small;color:#000000">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:#000000"><br></div><div class="gmail_default" style="font-family:arial,helvetica,sans-serif;font-size:small;color:#000000">SELECT <a href="http://ou.name">ou.name</a>, count(distinct <a href="http://circ.id">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">ou.id</a><br>WHERE <a href="http://ou.id">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:#000000"><br></div><div class="gmail_default" style="font-family:arial,helvetica,sans-serif;font-size:small;color:#000000">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:#000000"><br></div><div class="gmail_default" style="font-family:arial,helvetica,sans-serif;font-size:small;color:#000000">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:#000000"><br></div><div class="gmail_default" style="font-family:arial,helvetica,sans-serif;font-size:small;color:#000000">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:#000000"><br></div><div class="gmail_default" style="font-family:arial,helvetica,sans-serif;font-size:small;color:#000000">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:#000000"><br></div><div class="gmail_default" style="font-family:arial,helvetica,sans-serif;font-size:small;color:#000000">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:#000000"><br></div><div class="gmail_default" style="font-family:arial,helvetica,sans-serif;font-size:small;color:#000000">Thanks!</div><div class="gmail_default" style="font-family:arial,helvetica,sans-serif;font-size:small;color:#000000"><br></div><div class="gmail_default" style="font-family:arial,helvetica,sans-serif;font-size:small;color:#000000">John</div><div class="gmail_default" style="font-family:arial,helvetica,sans-serif;font-size:small;color:#000000"><br></div><div class="gmail_default" style="font-family:arial,helvetica,sans-serif;font-size:small;color:#000000"><br></div><div><div dir="ltr" class="gmail_signature" data-smartmail="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>