in reply to Re: Improving on MS-SQL over DBI and DBD::ODBC
in thread Improving on MS-SQL over DBI and DBD::ODBC

Hm... I will have to analyze this. I often work with 60k+ row counts. Thank you!


radiantmatrix
require General::Disclaimer;
Perl is

  • Comment on Re^2: Improving on MS-SQL over DBI and DBD::ODBC

Replies are listed 'Best First'.
Re^3: Improving on MS-SQL over DBI and DBD::ODBC
by jZed (Prior) on Nov 24, 2004 at 19:11 UTC
    The number of rows won't matter, this loops over the rows individually, just as fetchrow_hashref() does. The difference is that bind_cols() takes away some of the hash-creation overhead. The DBI docs unambiguously state that it is faster than fetchrow_hashref().