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:[email protected]] Sent: Thursday, May 28, 2009 10:21 AM To: Alex Massover Cc: [email protected] 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 <[email protected]<mailto:[email protected]>> 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:[email protected]<mailto:[email protected]>] Sent: Thursday, May 28, 2009 1:38 AM To: Alex Massover Cc: [email protected]<mailto:[email protected]> 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 <[email protected]<mailto:[email protected]>> wrote: I think perl module is most practical for you. -- Best Regards, Alex Massover VoIP R&D TL Jajah Inc. From: [email protected]<mailto:[email protected]> [mailto:[email protected]<mailto:[email protected]>] On Behalf Of Sharath Sent: Wednesday, May 27, 2009 12:42 AM To: [email protected]<mailto:[email protected]> 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 [email protected]<mailto:[email protected]> 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 [email protected]<mailto:[email protected]> 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 [email protected] http://lists.opensips.org/cgi-bin/mailman/listinfo/users
