[SR-Users] db connect needed by perl

["Nicolas Rüger"]

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

-- 
GRATIS! Movie-FLAT mit über 300 Videos. 
Jetzt freischalten unter http://portal.gmx.net/de/go/maxdome