Topic: mysql table restriction? (Page 1 of 1) Pages that link to <a href="https://ozoneasylum.com/backlink?for=27763" title="Pages that link to Topic: mysql table restriction? (Page 1 of 1)" rel="nofollow" >Topic: mysql table restriction? <span class="small">(Page 1 of 1)</span>\

 
AT
Bipolar (III) Inmate

From: Gainesboro, TN, USA
Insane since: Aug 2000

IP logged posted posted 04-10-2006 15:13 Edit Quote

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

hyperbole
Paranoid (IV) Inmate

From: Madison, Indiana, USA
Insane since: Aug 2000

IP logged posted posted 04-10-2006 18:20 Edit Quote

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.

_Mauro
Maniac (V) Inmate

From:
Insane since: Jul 2005

IP logged posted posted 04-10-2006 18:32 Edit Quote

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.

AT
Bipolar (III) Inmate

From: Gainesboro, TN, USA
Insane since: Aug 2000

IP logged posted posted 04-10-2006 19:09 Edit Quote

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

_Mauro
Maniac (V) Inmate

From:
Insane since: Jul 2005

IP logged posted posted 04-10-2006 19:56 Edit Quote

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



Post Reply
 
Your User Name:
Your Password:
Login Options: Remember Me On This Computer
 
Your Text:
Loading...
Options: Show Signature
Enable Slimies
Enable Linkwords

« BackwardsOnwards »

Show Forum Drop Down Menu