[OpenSIPS-Users] Sqlops in opensips ?

[Alex Massover]

We don't have any issues with perl module performance. It'a also been tested at 30-40 cps with 2 perl scripts per INVITE transaction, one initializes values like written below and another is a synchronous SOAP call to web-service.

Perl module precompiles the script code to executable on the first run, so there's no interpreting overhead.

--
Best Regards,
Alex Massover
VoIP R&D TL
Jajah Inc.
From: Brett Nemeroff [mailto:brett at nemeroff.com]
Sent: Thursday, May 28, 2009 10:21 AM
To: Alex Massover
Cc: users at lists.opensips.org
Subject: Re: [OpenSIPS-Users] Sqlops in opensips ?

It's been a while since I've needed this but I think gflags + avpops might be slightly more elegant. YMMV.

I'm not sure what the overheard to calling a perl function is (however i hear with the perl mod, it's very fast). I'd love to hear feedback on this....

-Brett

On Thu, May 28, 2009 at 1:42 AM, Alex Massover <alex at jajah.com<mailto:alex at jajah.com>> wrote:

Not exactly, but something like this is possible - the script will run on every INVITE transaction, but it will do a query only once at first run (once per every process/child).



You run a perl script for example on every INVITE, inside the script you have something like:





our $query_result;

unless(defined($query_result))

{

                $query_result=.........  #run your query here

}

#pass your query result to avp values or whatever







The $query_result will be stored in the memory.



--

Best Regards,

Alex Massover

VoIP R&D TL

Jajah Inc.

From: Sharath [mailto:sharath.kumar79 at gmail.com<mailto:sharath.kumar79 at gmail.com>]
Sent: Thursday, May 28, 2009 1:38 AM
To: Alex Massover
Cc: users at lists.opensips.org<mailto:users at lists.opensips.org>
Subject: Re: [OpenSIPS-Users] Sqlops in opensips ?



Is it possible to load *custom values from a database from a custom table during init time. Am I correct in assuming the AVPops module is scoped only for a call within a transaction ? Can the perl module be used to make a db query at init time ?

thanks for answering.
-Sharath

On Wed, May 27, 2009 at 7:46 AM, Alex Massover <alex at jajah.com<mailto:alex at jajah.com>> 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





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


This mail was received via Mail-SeCure System.

This mail was sent via Mail-SeCure System.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.opensips.org/pipermail/users/attachments/20090531/7efd391f/attachment.htm