On Oct 22, 2010, at 12:49 PM, "Nicolas Rüger" NicolasRueger@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/