> > Clarke, Darin wrote: > > >Hello, > > > >While breaking in a new desktop computer, I installed new > versions of > >the DBI, DBD-ODBC, and DBD-CSV. I have found the program > below (which > >takes records out of an Access DB with DBD-ODBC and puts them into a > >.csv file with DBD-CSV) > > > You do know that you can just save the Access db as CSV directly from > access don't you? > > In terms of what might have changed -- the most likely culprit is > SQL::Statement (one of the prereq modules for DBD::CSV), try > installing > the old SQL::Statement from Jochen Wiedmann's directory (any version > before 1.0) and see if that changes the speed. If it does > please write > me off list with the details (I maintain the newer > SQL::Statement which > is slower but better though I wouldn't suspect it would be as slow as > you describe so maybe something else is going on).
I'd also suggest just reading the data with DBD::ODBC first and timing the differences between the old version and the new. It's possible that something in DBD::ODBC is the culprit, or, even the version of the ODBC driver (if different...) Regards, Jeff
