MySQL Forums
Forum List  »  Performance

Re: Optimizing a query to out-perform MS Access (easy, right?)
Posted by: Nicklas Forsberg
Date: October 16, 2005 10:59AM

We had similar problems and i just solved my so i thought i post a copy of my solution here :)

---
It's SOLVED! W000t, yay :)

It was the MDAC files for ADO routines that where older in the end-user system than my programming enviroment. 2.7 was installed and my software was set on 2.8. After some more research i saw that Windows XP Servicepack 2 has 2.8.1. I thought that i already had SP2 installed on this machine. After installing SP2 and the new MDAC files it worked perfectly.

From 40 seconds to 2 seconds.. yay ;)

:)
---

Hope it might help.
Sincerely
Nicklas Forsberg
www.nalf.se

Options: ReplyQuote




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.