The biggest issue is that you are connecting to SQL Server and not getting
multiple result sets (seemingly). I wouldn't worry about it, unless your
application needs to handle multiple result sets in a single query.
Also, on Solaris, FreeTDS and DBD::Sybase is probably the way I'd start, just
-- LLC [EMAIL PROTECTED]
I've heard that perl-DBI is slow. Is this true? If so, is it because of
Perl being an interpreted language?
Perl is compiled, always has been.
DBI is no slower than any other application that has to
talk to a database. This involves disk and/or network I/O,
-- Alexander Foken [EMAIL PROTECTED]
You generate a big number of open statement handles, each costing some
memory. Put the SQL statements (*NOT* the statement handles) into a hash,
like this:
use DBI;
my %statements=(
'find_users' = 'select foo,bar from users where baz=?',
Hello,
Installing DBI-1.51 - 'make test' returns results that seem strange. Any
tests that 'use Storable' attempt to load an old version installed under
Perl 5.6. A newer version of Storable is installed under Perl 5.8. The
new version is in @INC prior to the old version. Since I'm installing
DBI
Thanks for the help Tim! You've really done me a great service.
I have created the following patch, which appears to fix all of the leaks. Can
you please review it, and give it your stamp of approval? I am willing to use
this patch if you approve it, until a new DBI is available with the