MySQL Forums
Forum List  »  Microsoft Access

Advanced Search
New Topic

Norbert Paprocki - Access database with over 500k records be faster in MySQL
Posted by: Norbert Paprocki
Date: October 28, 2009 08:43PM

Hi Folks,

Sorry if this is a stupid question.

I have an access database that we find is running very slowly for queries.
We had a local developer look at it and he said because it had so many records (a little over 500,000) that it would be best if we considered using MySQL and have Access as the front end.

I am curious if anyone else has done this and has the speed improvement been worth the conversion. We anticipate the database to grow at a rate of 50,000 records per year.

Navigate: Previous Message• Next Message
Options: Reply• Quote


Subject
Views
Written By
Posted
Norbert Paprocki - Access database with over 500k records be faster in MySQL
4388
Norbert Paprocki
October 28, 2009 08:43PM


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.