gflags + avp_db_load should be able to do much much more than this without a problem.. even gflags + the perl module would be better<div><br><br><div class="gmail_quote">On Thu, May 28, 2009 at 9:18 AM, Alex Balashov <span dir="ltr"><<a href="mailto:abalashov@evaristesys.com">abalashov@evaristesys.com</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex;">60,000 times a day is about 41 times a minute (or, a little less than<br>
one operation per second), assuming uniform distribution.<br>
<br>
That probably won't stress it too badly. My issues were with bigger loads.<br>
<div><div></div><div class="h5"><br>
Jeff Pyle wrote:<br>
<br>
> For what it's worth, I use the perl module to execute some custom database<br>
> operations for custom route decision making. It runs about 60k times per<br>
> day in a Xen VM with no memory or performance issues. I've been quite<br>
> pleased.<br>
><br>
><br>
> - Jeff<br>
><br>
><br>
><br>
> On 5/28/09 8:46 AM, "Alex Balashov" <<a href="mailto:abalashov@evaristesys.com">abalashov@evaristesys.com</a>> wrote:<br>
><br>
>> Admittedly, OpenSER 1.3.x was the last time I tried the Perl module, but<br>
>> my performance results with the Perl module have been very bad, and<br>
>> there are memory leaks in it as well.<br>
>><br>
>> I think much of it has to do with the fact that the maintainer has been<br>
>> effectively unavailable for several years.<br>
>><br>
>> Not sure if anything has happened to the Perl module in OpenSIPS since then.<br>
>><br>
>> Alex Massover wrote:<br>
>><br>
>>><br>
>>><br>
>>> I think perl module is most practical for you.<br>
>>><br>
>>><br>
>>><br>
>>> --<br>
>>><br>
>>> Best Regards,<br>
>>><br>
>>> Alex Massover<br>
>>><br>
>>> VoIP R&D TL<br>
>>><br>
>>> Jajah Inc.<br>
>>><br>
>>> *From:* <a href="mailto:users-bounces@lists.opensips.org">users-bounces@lists.opensips.org</a><br>
>>> [mailto:<a href="mailto:users-bounces@lists.opensips.org">users-bounces@lists.opensips.org</a>] *On Behalf Of *Sharath<br>
>>> *Sent:* Wednesday, May 27, 2009 12:42 AM<br>
>>> *To:* <a href="mailto:users@lists.opensips.org">users@lists.opensips.org</a><br>
>>> *Subject:* [OpenSIPS-Users] Sqlops in opensips ?<br>
>>><br>
>>><br>
>>><br>
>>> hello,<br>
>>> Is there any module equivalent to sqlops of openser in opensips ?<br>
>>> Basically I want to run sql queries from proprietary tables and use them<br>
>>> in the route script file.<br>
>>><br>
>>> thank you<br>
>>> -Sharath<br>
>>><br>
>>> This mail was received via Mail-SeCure System.<br>
>>><br>
>>><br>
>>><br>
>>> This mail was sent via Mail-SeCure System.<br>
>>><br>
>>><br>
>>> ------------------------------------------------------------------------<br>
>>><br>
>>> _______________________________________________<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>
><br>
<br>
<br>
</div></div>--<br>
<div class="im">Alex Balashov<br>
Evariste Systems<br>
Web : <a href="http://www.evaristesys.com/" target="_blank">http://www.evaristesys.com/</a><br>
Tel : (+1) (678) 954-0670<br>
Direct : (+1) (678) 954-0671<br>
Mobile : (+1) (678) 237-1775<br>
<br>
_______________________________________________<br>
</div><div><div></div><div class="h5">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></div></blockquote></div><br></div>