CODEWITHSUNDEEP
phpmysqlsql
user1217974
user1217974

Reputation: 154

Does having 550 tables in MySQL slow down the performance?

I know that there is no limit on the number of tables the MySQL can have and I've also come to know that it doesn't affect much.

But I want to know this. I have around 550 tables in 1 DB, and I get more than 50000 visitors to my site, does it slow down?

The site is designed in PHP and in a way that one query takes data from 1 table and leads to another query which takes the data from same table. Does it slow down with so many visits daily?

Upvotes: 0

Views: 674

Answers (1)

GolezTrol
GolezTrol

Reputation: 116110

It slows down, when you get more data in the tables or execute more (or more complex) queries. A table itself doesn't slow down MySQL. You can add as many tables as you like without performance penalties. More visitors (more queries) does, however.

Upvotes: 4

Related Questions