On Oct 22, 2010, at 12:49 PM, "Nicolas Rüger" <[email protected]>
wrote:
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.
No, the connection handles are persistent. That is one of the
advantages.
so 2 questions...
1.) Is that true or am I wrong?
You are wrong. :-)
2.) Will using SQLOPS lead to a much better performance than
querying the database from perl scripst?
Yes, much less overhead; no external script invocation required, not
as much blocking, connection already open, etc. Unless you have a
specific need to run a Perl script because only Perl can do something
you especially need, definitely use sqlops for general DB operations.
--
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/
_______________________________________________
SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing list
[email protected]
http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users
