in reply to How to count rows using DBI & mysql - Performance results
Not sure whether the do() is portable. The DBI code seems to suggest that some drivers return -1 untill all rows are fetched. Not sure if this would propagate back through the do() result.I can confirm that it indeed does return -1, with a recent version of DBD::ODBC, and MS Access. It's a trick you should only use very cautiously.
|
|---|