Mysql

Paul00000001 · September 7th, 2006, 08:38 AM

Hey i have a question, i have been learning how to use mysql and am about to build the database but i have been reading that mysql is perfect for small websites but not for larger ones as it uses ten times more space than a access database. But i have also read that access crashes when 10 users access the database simultaneously but i have also read that it doesnt but it does crash when ten editors access the database.

So my question is can you use access on a webpage that is being viewed by many users at once and if so when is mysql used?.

moojoo · September 7th, 2006, 08:42 AM

MySQL is completely capable of handling large sites and loads. Access would be my last choice personally. This site runs off of a MySQL DB I believe as well.

Paul00000001 · September 7th, 2006, 08:46 AM

but can access handle lots of users accessing the database at one time as people say its designed to only be a desktop database

moojoo · September 7th, 2006, 09:03 AM

I couldn't tell you, we use Access at work but most of my experience is with MySQL and MSSQL. Here are some specs on Access: http://www.databasedev.co.uk/access_...s.html#General

ukgeoff · September 7th, 2006, 11:50 AM

As this is a web forum one must assume that you are talking about a backend database on a web server.

That being the case, forgat about Access. Your only practical choice is one of the sql variants. If you want free, then that pretty much brings it down to MySQL. There must be a reason why so many hosting facilities offer this as part of the PHP/Apache installation.

Go with MySQL.

Gee Bee · September 9th, 2006, 04:54 AM

The place I used to work used an access database for thier contact management system and it certainly had problems when more than 10 connections were made to it, that may have been that it was poor written in the first place or a whole host of other reasons by since then i have also heard from others that they've have problems with access when using more than 10 connections.

As for mysql I think alot of the negativity is from the older days when some features such as enforced references(i think) and stored procedures weren't available. If you check out who they say uses mysql (http://www.mysql.com/customers/) its an impressive list including yahoo, French Ministry of Defense, and google, although im not sure what they are using the database for!

moojoo · September 9th, 2006, 02:05 PM

MySQL is/has been awesome in the 5 years I have used it. I just don't see any other DB system working better for my needs anyway.

masonbarge · September 13th, 2006, 05:48 PM

I think Access is primarily used in offices for standalone or network systems. MySQL seems to be big for remote server/internet use. Although either can be used for either.

There's nothing any better than mysql until you get up in the Oracle range.