Slower than MS Access
We did a successful migration from MS Access to MySQL of the database related to our software designed in VB6. We configured all things related to MyODBC and MySQL Server. Our unique problem is the speed to get a recordset from a SQL query. A query posted to Access via ADO was really fast, but to MySQL with MyOBDB, it can take easily more than twice the time. We were surprised by this fact because MySQL should be much faster.
Can anyone explain this ?
Subject
Views
Written By
Posted
Slower than MS Access
2516
July 08, 2005 09:00AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.