I have heard (no first hand experience) that MySql does not support transactions well. if you're doing many reads and few writes you should be OK. if your site envolves alot of user interaction (CUD operations) then I would also suggest Postgresql. it is very similar to MySql but has better transaction support. If you have control over the db platform it's worth a look.
if your only other option is MS Access then definately go with MySql.
both MS access and MySql have a concurrent user limt which is low, access being lower, i've never had a problem with t-sql on mysql, read somewhere that mysql eats more resourses that sql server for processing, with mysql use a power house computer.
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.