[OpenSIPS-Users] Sqlops in opensips ?

Alex Balashov abalashov at evaristesys.com
Thu May 28 16:28:15 CEST 2009


Right, but we're talking about the Perl module.

Brett Nemeroff 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 <mailto: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
>     <mailto: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>
>      >>> [mailto: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 <mailto: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 <mailto: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 <mailto: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



More information about the Users mailing list