[OpenSIPS-Users] Sqlops in opensips ?

[Alex Balashov]

Oh, heaven knows I don't use the perl approach anymore.  I was just 
remembering.

Jeff Pyle wrote:

> 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
> 
> 
> 


-- 
Alex Balashov
Evariste Systems
Web    : http://www.evaristesys.com/
Tel    : (+1) (678) 954-0670
Direct : (+1) (678) 954-0671
Mobile : (+1) (678) 237-1775