Can you have too many tables in a MySQL database?

[sclewin]

Hi,

I just noticed that the number of tables in my database are growing. I was just wondering if there was a limit I should keep under.

 

[tittat]

duplicate post
look here http://forums.x10hosting.com/free-hosting/52285-mysql-database-limit.html

 

[sclewin]

duplicate post
look here http://forums.x10hosting.com/free-hosting/52285-mysql-database-limit.html

Tank you, I only thought the size limit was 10mb. So, is the only limit to the number of tables the limit of information you put on them?

 

[Sohail]

You can never have too many tables . I think the limit is 10 megs too though...

 

[sclewin]

You can never have too many tables

Thank you that was the answer I was looking for.

. I think the limit is 10 megs too though...

I thought it was because I am pretty sure I read that somewhere.

 

[sunils]

if i am correct there is not restriction on the database site untill you have enough free space in your account. about the number of table, its better that you reduce your table size to have a better access and reterival time.. That what about a good database design.

 

[sclewin]

about the number of table, its better that you reduce your table size to have a better access and reterival time. That what about a good database design.

Okay, so it is better to have smaller tables instead of a few big ones.

 

[AutoItKing]

Okay, so it is better to have smaller tables instead of a few big ones.

True. It's much easier to find something in many small books, than in one huge one. Or find a red ball in many containers of pink balls, than in one huge container. Or . . . a needle in a small haystack, rather than a big one. Shall I go on? Or do you get the idea?

 

[sclewin]

True. It's much easier to find something in many small books, than in one huge one. Or ...

Yes I did, thank you. LOL