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