Can anyone give some stats, or links to comparisons, between MS Access and MySQL hosted databases? I know the general answer is MySQL is better, but I'm wondering in what ways, and at what point, performace/traffic wise.
I'm involved in a small site that is currently running off Access just fine, but looking to the future, there will be more and more users doing more and more database related activities, and I'm wondering at what point Access fizzles out and MySQL is wise to port over to.. in terms of the amount of work being performed by the database (users will be changing their details, posting messages, uploading images etc.. so this kind of "simple" stuff, nothing terribly complex.)
Are there any articles that provide details and compare the performance of these two database environments in small-to-large scale applications? Meaning.. an article that talks about the positives and negatives of each database for different application sizes would be nice (since we're going to be transitioning from small to large). Any help or links are appreciated!
I'm involved in a small site that is currently running off Access just fine, but looking to the future, there will be more and more users doing more and more database related activities, and I'm wondering at what point Access fizzles out and MySQL is wise to port over to.. in terms of the amount of work being performed by the database (users will be changing their details, posting messages, uploading images etc.. so this kind of "simple" stuff, nothing terribly complex.)
Are there any articles that provide details and compare the performance of these two database environments in small-to-large scale applications? Meaning.. an article that talks about the positives and negatives of each database for different application sizes would be nice (since we're going to be transitioning from small to large). Any help or links are appreciated!