in reply to Access Database
Update: Apparently, DBD::ADO is even slower than ODBC. I benchmarked selecting 5000 rows using selectall_hashref() and DBD::ODBC is about 25x faster than DBD::ADO. But, I also had to rewrite my query into a format that would be accepted by ODBC. DBD::ADO will accept a straight Access Query, while ODBC will not.
Also, DBD::ODBC requires you to manually set up an ODBC DSN before hand, while with DBD::ADO you do not.
|
|---|