Is MySQL faster than Access? PHP faster than ASP?

Will the CMS be faster in PHP/MYSQL?

[Livenomadic]

I'm found a great CMS that I am absolutely loving the features. However currently it is avaliable only in ASP/Access.

Currently they are working on a PHP/MySQL version of the CMS which should be avaliable in two months (the timeing in perfect for me).

When the PHP/MYSQL version is released, will pages load faster than they currently do on the ASP/Access?

Thanks!

[Dreamquick]

There's normally very little difference between a well written PHP or ASP web-application, however in the grand scheme of things moving away from Access will normally help improve stability as Access wasn't really designed to be used as a web-based multi-user database.

If you don't percieve your website as slow at the moment I doubt you'd see a measurable speed increase by moving to MySQL, however as you add more users/traffic I'd expect MySQL to scale with minimal effort where Access will sometimes just stop working.

- Tony

[karmov]

Someone I know had some work done for them in access. It was great on a small scale but completely died when it was populated with a largish set of data. MySQL is much more tolerant to scaling. If you are looking for an MS product that will scale well you could look into MSSQL. I don't personally know much about it except that it's their "big" database whereas access is mostly geared towards small projects.

[Dreamquick]

MS SQL is at a similar level to mySQL in that they are both solid database management systems, however you typically find that mySQL is the lower cost option which is great if you don't need all the full ranges of abilities offered by commercial database systems.

- Tony

[mincklerstraat]

If you really need speed, you could add some kind of lightweight caching script to the pages that you don't change more than 5 minutes or so (also, don't put this in the 'admin' part of your site). Easiest I've used so far is jpcache. Only for php though. Your cms people might be able to incorporate it for you since it's very easy if you don't have a lot of 'hello user John your birthday is in 89 days' kind of stuff that is user-specific.