MySQL Limitations

Hi,

I was wondering if anyone could detail to me the limitations of MySQL. I've heard various stories about it not handling databases with large numbers of records (100,000+) very well, and about problems with updating, editing, search and replace, etc with MySQL. I'm looking for confirmation of these or information that states otherwise. I have a large site with 200,000 records that will have to be allowed to be updated, edited, removed all from the website.

Thanks in advance,
Darcy

Mysql can handle 200K rows easily. i was on the mysql listserve and there were people on there running millions of rows. the actual limit on database size is imposed by your operating system, not by mysql. mysql is small and fast, but lacks some of the advanced functions of other databases, transactions, rollback, subqueries. normal people don't even really need these features, though, so it doesn't matter. not having these addons is what keeps it so fast, also. let's not forget it's FREE and very well documented.

my $0.02

---John Holmes...

I tried to email you back, but it got returned to me, user unknown.

Feel free to ask me any questions and I'll try and answer what I can. I'm not a professional, but I use php and mysql a lot for web developement.

what would you need subqueries and transactions for in a web environment? or is this going to be used for other purposes, too?

---John Holmes...