Should product categories be separated?

Question

MySQL

Good evening. There is not a big store with about 600 positions. In a month we plan to increase the line up to 11-12k positions. Does it make sense to separate product categories from one table into several? In each category there will be about 1-2k positions.

Answer 1

The division of the same type of models into different tables is very difficult to maintain relationships in relational databases. That is, it will only complicate the work of you, the developers.
If you are worried about speed, then it is not worth it, with a normally configured database cache, it can handle millions of records per table