<html>
<head>
</head>
<body class='hmmessage'><div dir='ltr'>
<style><!--
.hmmessage P
{
margin:0px;
padding:0px
}
body.hmmessage
{
font-size: 10pt;
font-family:Tahoma
}
--></style>
<div dir="ltr"><div><div dir="ltr">I detected this problem when I was using a table with 150000 records in billing rates history, and 70000 records in destinations table. But I would like use without problems tables with 300000 records or more and i think to put more memory in my server doesn't mean to solve the error. <div><br></div><div>With this data tables the server works without problems at the beginning, using 500MB of memory. But when I make the reload, the rating engine doesn't release the memory that used as before so the others applications work slower. In my opinion the rating engine doesn't need keep this memory.</div><div><br></div><div>Daniel<br><br><div><div id="ecxSkyDrivePlaceholder"></div><hr id="ecxstopSpelling">From: ag@ag-projects.com<br>Date: Mon, 19 Mar 2012 19:50:00 +0100<br>To: users@lists.opensips.org<br>Subject: Re: [OpenSIPS-Users] CDRTool - memory problem<br><br>
<div>Can you describe more accurately what 'large tables of data' means?</div><div><br></div><div>Adrian</div><div><br></div><div><div><div>On Mar 19, 2012, at 6:31 PM, Daniel Conte Laguna wrote:</div><br class="ecxApple-interchange-newline"><blockquote><span class="ecxApple-style-span" style="border-collapse:separate;font-family:Helvetica;font-style:normal;font-variant:normal;font-weight:normal;letter-spacing:normal;line-height:normal;orphans:2;text-align:-webkit-auto;text-indent:0px;text-transform:none;white-space:normal;widows:2;word-spacing:0px;font-size:medium"><div class="ecxhmmessage" style="font-size:10pt;font-family:Tahoma"><div dir="ltr"><blockquote style="background-color:rgb(255, 255, 255)"><span class="ecxApple-style-span" style="border-collapse:separate;line-height:17px"><div class="ecxhmmessage"><div dir="ltr"><font color="#2a2a2a"><div>Hello everybody,</div><div><br></div><div>I'm working with CDRTool and I found a problem of memory.</div><div>I have to work with large tables of data, which increases the memory usage during the execution.</div><div><br></div><div>My problem appears when I make any change in the destination table, after this, is enabled Reload rating tables in red. </div><div><br></div><div>After reload of rating tables, ratingengine.php start to use large amount of memory that never be release, causing speed problems on my server. This memory is released only when I stop manually CDRTool. </div><div><br></div><div>Is the problem perhaps here;</div><div><br></div><div>function reloadRatingEngineTables () {</div><div>.........</div><div><br></div><div> // init CDR datasource</div><div>$CDR_class = $DATASOURCES[$RatingEngine['cdr_source']]['class'];</div><div>$CDRS = new $CDR_class($RatingEngine['cdr_source']);</div><div>// is the following line necessary - is memcache still used ???</div><div><br></div><div>$CDRS->CacheDestinations();</div><div><br></div><div>Best regards and thanks</div><div>Daniel Conte</div></font></div></div></span></blockquote></div>_______________________________________________<br>Users mailing list<br><a href="mailto:Users@lists.opensips.org">Users@lists.opensips.org</a><br><a href="http://lists.opensips.org/cgi-bin/mailman/listinfo/users" target="_blank">http://lists.opensips.org/cgi-bin/mailman/listinfo/users</a><br></div></span></blockquote></div><br></div><br>_______________________________________________
Users mailing list
Users@lists.opensips.org
http://lists.opensips.org/cgi-bin/mailman/listinfo/users</div></div> </div></div></div>
</div></body>
</html>