On Oct 22, 2010, at 12:49 PM, "Nicolas RĂ¼ger" <NicolasRueger(a)gmx.de>
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/