<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
</head>
<body style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space; color: rgb(0, 0, 0); font-size: 14px; font-family: Calibri, sans-serif;">
<div>Hi</div>
<div><br>
</div>
<div>I have set up CDRTool to read CDRs from my radius database for OpenSIP calls. I am successfully rating calls, but everytime I search for CDR records using the </div>
<div>CDRTool GUI it takes 1-3 minutes before the search result window is shown.</div>
<div><br>
</div>
<div>If there are no matching records the result window is shown immediately. Does anyone else have any experience with this? I suspect that there might be a database lock,</div>
<div>Database connection pool problems or just some configuration error somewhere.</div>
<div><br>
</div>
<div>In my browser I get the following in my developer console / network (note the huge duration for the HTTP POST):</div>
<div><br>
</div>
<div>200 POST<span class="Apple-tab-span" style="white-space:pre"> </span>callsearch.pthml<span class="Apple-tab-span" style="white-space:pre">
</span><destip><span class="Apple-tab-span" style="white-space:pre"> </span>html<span class="Apple-tab-span" style="white-space:pre">
</span>105.41 kb<span class="Apple-tab-span" style="white-space:pre"> </span>150212 ms</div>
<div>200 GET<span class="Apple-tab-span" style="white-space:pre"> </span>date picker.css<span class="Apple-tab-span" style="white-space:pre">
</span><destip><span class="Apple-tab-span" style="white-space:pre"> </span>css<span class="Apple-tab-span" style="white-space:pre">
</span>9.96 kb<span class="Apple-tab-span" style="white-space:pre"> </span>14 ms</div>
<div><br>
</div>
<div>Followed by several lines of </div>
<div>304 GETs</div>
<div><br>
</div>
<div><br>
</div>
<div>When checking with Wireshark I notice that after the HTTP POST to callsearch, I get several TCP Keep-Alive messages as the server is slow..</div>
<div>After 2m 38 seconds everything is suddenly released and some HTTP GETs make the page to update.</div>
<div><br>
</div>
<div>I see nothing in syslog (from cdrtool) but some mysql connection statements.. No lock/unlock or similar statements..</div>
<div><br>
</div>
<div>
<div>I appreciate if anyone could enlighten me on this subject.</div>
<div><br>
</div>
</div>
<div><br>
</div>
<div>Best Regards,</div>
<div>Tomas Andersen</div>
<div> </div>
<div>
<div id="MAC_OUTLOOK_SIGNATURE"></div>
</div>
</body>
</html>