How powerful is MySQL?

Anon

I am convincing my boss to change from Access DB to MySQL, he wants to set up a site with more than 70,000 records, would MySQL hold this right?

Do you guys know about a place running with MySQL that is holding many records?

Thank you
A PHP/MySQL fighter.

Anon

it is more powerful then a flat text database. I'm sure mysql db can hold more than 1,000,000 records. It is really fast, but with 1,000,000 records, it might slow it down. Not 100% sure, but I use it and i have about 1,000 records and its extremely fast when organizing the data from tables.

jnutter

Yes. MySQL will handle that no problem.

I've built quite a few MySQL/PHP sites and at least one of them (to my knowledge) now has more than 50,000 user accounts with each user able to create up to ten different (medium-size) text reports to go with their account. Potentially half a million records... and the site is still nice and peppy. Runs fast runs good no complaints.

Also.. Access should NOT (in my opinion) ever be used in a production environment to run a business-critical web application. It was never meant for that in the first place (that's why Microsoft sells their OTHER database MSSQL for scads and practically gives Access away with their Office packages).

Access is meant for small personal databases or maybe even a small office-wide application but beyond that... it chokes.

That's my 2cents 😉

nutter

Anon

FWIW, My site contains over 10,000 records in a certain table (each with about 50-60 lines of text each, some more, some less) and it's as fast as ever.

Anon

I use SQL databases A LOT on my site...I don't have quite as many entries as people have been mentioning but it is really fast and reliable.

One thing I should mention:

With the experiences I've been having (and depending on the reliability of your server) I strongly consider backing up your data on a DAILY BASIS from the server into a CSV format document.

Anon

I have serveral MySQL databases with well over 50 million rows in each one. I can do a query on any of the database in less then .10 of a second. MySQL is VERY powerful (just make sure you read the docs on MySQL on how to optimize)

Anon

Hehe, yeah, MySQL would definitel be a competitor to Access. With it's table level locking I wouldn't say much more than that though 🙂

vex__

http://www.mysql.com/information/benchmarks.html

Should give you all the information you need!

neuromancer

MySQL will do this, but I would recomend Microsoft SQL server (Any version 6.5+).