Will MySQL manage to serve about HUNDRED to 500 end users concurrently I guess that may be my main problem. Will a website dependant on database be sluggish or faster than the usual more traditional website where it is mainly based about individual files
Effectively, that’s a little an ambiguous dilemma. Yes it can handle that many users.
Are you drinking slower Much reduced. Much much very much slower. If that you’re worried about speed, look into caching.
MY SPOUSE AND I often build databases backend websites making use of Access, Mysql as well as SQL.
To your requirements Access will in all probability strain at high, but MySql and SQL will contend fine.
Are you drinking slower, yes theoretically, but as long as there is a good database device, and good rule, you won’t detect any different. It’s a bit just like the argument should you host in england or the INDIVIDUALS. The speed variance is so little so it makes no difference in any way.