<HTML>
<HEAD>
<TITLE>Re: [OpenSIPS-Users] Sqlops in opensips ?</TITLE>
</HEAD>
<BODY>
<FONT FACE="Tahoma, Verdana, Helvetica, Arial"><SPAN STYLE='font-size:10pt'>It’s during business hours. We sipp-tested it at 40 cps without an issue. I probably should have mentioned that. In our case we have to evaluate the costs returned by some stored procedures, mix in some spices, fluff the egg whites, flash fry and return a route list.<BR>
<BR>
Brett’s right. In your application, gflags sound like the hot ticket.<BR>
<BR>
<BR>
- Jeff<BR>
<BR>
<BR>
On 5/28/09 10:23 AM, "Brett Nemeroff" <<a href="brett@nemeroff.com">brett@nemeroff.com</a>> wrote:<BR>
<BR>
</SPAN></FONT><BLOCKQUOTE><FONT FACE="Tahoma, Verdana, Helvetica, Arial"><SPAN STYLE='font-size:10pt'>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<BR>
<BR>
<BR>
On Thu, May 28, 2009 at 9:18 AM, Alex Balashov <<a href="abalashov@evaristesys.com">abalashov@evaristesys.com</a>> wrote:<BR>
</SPAN></FONT><BLOCKQUOTE><FONT FACE="Tahoma, Verdana, Helvetica, Arial"><SPAN STYLE='font-size:10pt'>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>
<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="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="users-bounces@lists.opensips.org">users-bounces@lists.opensips.org</a><BR>
>>> [<a href="mailto:users-bounces@lists.opensips.org">mailto:users-bounces@lists.opensips.org</a>] *On Behalf Of *Sharath<BR>
>>> *Sent:* Wednesday, May 27, 2009 12:42 AM<BR>
>>> *To:* <a href="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="Users@lists.opensips.org">Users@lists.opensips.org</a><BR>
>>> <a href="http://lists.opensips.org/cgi-bin/mailman/listinfo/users">http://lists.opensips.org/cgi-bin/mailman/listinfo/users</a><BR>
><BR>
<BR>
<BR>
--<BR>
Alex Balashov<BR>
Evariste Systems<BR>
Web : <a href="http://www.evaristesys.com/">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>
Users mailing list<BR>
<a href="Users@lists.opensips.org">Users@lists.opensips.org</a><BR>
<a href="http://lists.opensips.org/cgi-bin/mailman/listinfo/users">http://lists.opensips.org/cgi-bin/mailman/listinfo/users</a><BR>
</SPAN></FONT></BLOCKQUOTE><FONT FACE="Tahoma, Verdana, Helvetica, Arial"><SPAN STYLE='font-size:10pt'><BR>
<BR>
</SPAN></FONT></BLOCKQUOTE>
</BODY>
</HTML>