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

Also, I don't know how quickly you can connect to the database, but I've seen new connections to an oracle database take up to 20 seconds.
MS-SQL (and Sybase) is pretty good in that respect - creating a new connection is a relatively fast operation, though that doesn't invalidate your point - reconnecting over and over is not a good thing (especially over a slow link)

Michael

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