[OpenSIPS-Users] Sqlops in opensips ?

Jeff Pyle jpyle at fidelityvoice.com
Thu May 28 16:28:30 CEST 2009


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.

Brett¹s right.  In your application, gflags sound like the hot ticket.


- Jeff


On 5/28/09 10:23 AM, "Brett Nemeroff" <brett at nemeroff.com> wrote:

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

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.opensips.org/pipermail/users/attachments/20090528/946c2010/attachment-0001.htm 


More information about the Users mailing list