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

If you're on Win32, one alternative is DBD::ADO. There are some different limitations versus ODBC, but overall it works well.

That said, I have to echo what others have also written. It's very unlikely that any slowness you're experiencing is from DBI or any of the DBD layers. The culprit is most often a data model that's unsuitable for what you're trying to do, or code that doesn't work well with a given model (doing row-by-row processing is often a problem, for instance).

It's hard to answer your question in general terms. You may want to post some code and/or design ideas, and ask for specifics.

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