Hello Alex,
thank you for the tips.
I had a look at SQLOPS and it seems that it will open a new connection as well, every time that "sql_query(connection, query, result)" is called.
so 2 questions...
1.) Is that true or am I wrong?
2.) Will using SQLOPS lead to a much better performance than querying the database from perl scripst?
Thank you...
Regards,
Nicolas
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'?