What is more productive in mysql (innodb) several small tables or one large one?

Question

MySQL

What is better for performance and saving iron resources - split data into several tables or have one big one?

1,000,000 records of 0.03 MB each.

Product table. Sorting of goods, search for goods, rating on the main page. Random goods.

Answer 1

Tables should be designed so that the data of one entity is not "smeared" across different tables.
And several long tables are better than one wide one. But at the same time, so that there is as little need for JOIN as possible.
It is better to separate the product rating from the products because it changes relatively often.
Without the structure of the tables and what queries it is impossible to give specific advice.

Answer 2

a few, of course,
if you know what you're doing)))