Beefy Boxes and Bandwidth Generously Provided by pair Networks
Come for the quick hacks, stay for the epiphanies.
 
PerlMonks  

Re: Improving on MS-SQL over DBI and DBD::ODBC

by MrCromeDome (Deacon)
on Nov 24, 2004 at 15:48 UTC ( [id://410151] : note . print w/replies, xml ) Need Help??


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

I haven't worked much with it, but have you considered using DBD::ADO as an alternative? Reasoning being that ADO is a Microsoft-created data access protocol, and therefore may be somewhat more speedy than using ODBC. And by using DBD::ADO, you could keep all of your existing code, and all future code benefits from what DBI provides.

Give it a shot, you have nothing to lose. Wish I had some benchmarks for you to confirm my theories ;)

Good luck!
MrCromeDome

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