I make an online store and I am going to create a new table for each category of goods in the database. How bad or good is it? What happens if there are a thousand or a few thousand categories?

  • nothing wrong with that - Aslan Kussein
  • Do you have each category its own set of product properties? And they (properties) are very different in different categories? - Visman
  • Yes, I first tried to create a table with properties more precisely with something like a model of properties, connect it with a table of properties and then just screw it to a table with categories. But there were problems with the fact that different properties require a different format and length of cells and generally require a complex connection between themselves - Stanislav Dalinin
  • I suppose that relational databases are in principle not suitable for the task being described - andreymal
  • one
    Check out google.com/… - Visman

1 answer 1

You will then suffer from a large number of tables. I propose to organize the data in the database in the form of a tree. Since you do not know the number of categories, and they will only grow. With hierarchical tables, queries you can find here .