[SR-Users] db connect needed by perl

[Alex Balashov]

On 10/22/2010 10:30 AM, "Nicolas Rüger" wrote:
> Hello,
>
> I have PERL script that's executed for every(!) initial INVITE message from the routing logic.
>
> The script needs to lookup a table in the database. Therefore I need to connect to the database each time a initial INVITE is routed.
>
> That might kill the performance (not tested yet, but pretty sure).
>
> How can PERL get access to the database without establishing a _new_ connection each time???

You can try pgpool or mysqlproxy for persistent connections. 
Otherwise, Perl scripts don't persist that way in this module.

Can't you do what you need to do with 'sqlops'?

-- 
Alex Balashov - Principal
Evariste Systems LLC
1170 Peachtree Street
12th Floor, Suite 1200
Atlanta, GA 30309
Tel: +1-678-954-0670
Fax: +1-404-961-1892
Web: http://www.evaristesys.com/