22 Oct
2010
22 Oct
'10
4:49 p.m.
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
--
GRATIS! Movie-FLAT mit über 300 Videos.
Jetzt freischalten unter http://portal.gmx.net/de/go/maxdome
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'?