I was reading about databases with a ton of tables on Stack Overflow and I found that some people feel there is a performance impact when there is too many MySQL tables on a server. But in the same breath, it caused a huge debate with people who disagree. I'm just wondering if there's a proven answer? Maybe with trials or something?
I know database normalization may result in many tables, which has me so confused. Of course, I know, normalizing all of your data helps the health of your database in the long run, but it also creates more MySQL tables, which some say cause a performance impact, so does anyone have a straight answer to this? XD