Topic awaiting preservation: mysql table restriction?

Hello!

I have a client, his hosting account only allows for one DB (MySQL) and he was asking me if it would work with 200 tables.

I didn't know of any restrictions, but I wanted to ask the community.

Thanks for your help.

Cheers

Casey / AT
Personal
Song Lyrics
Family Recipes

The answer to your question will depend on the version of MySQL, the operating system, and the size of each table. I don't know of any restrictions on the number of tables you can create in MySQL only on the size of the database, which is limited to 8 terabytes as of version 4.0. I'm not saying there are no restrictions on the number of tables, I just don't know of any.

As long as you're within the database size limit you should not have a problem creating 200 tables in a database. I can't imagine that any limit on the number of tables in MySQL would be anything close to 200.

.



-- not necessarily stoned... just beautiful.

Beware of inner joins also on MySQL, inner joins will only work as real constraints if you are using InnoDB tables (and it's a hassle to configure).

If you *have* to have 200 tables (my, now that's a huge thing, 200 tables... I am not even sure the FBI
use databases of that size - hint, 200 tables is too much for most business needs, it shouts out *bad db design*),
opt for another free solution.

PostGre(sql) for instance.

Hello

Thank you both.

The 200 tables aren't actually for one site, but about 112 right now.

Thanks for your time, its greatly appreciated.

Cheers,

Casey / AT
Personal
Song Lyrics
Family Recipes

*cough. ~blushes. Ah, yeah, now that I come to think of it, that is a valid business reason indeed.
Cheers.