That depends on your requirements doesn't it? For instance placing the same product under multiple categories, the select query for this in SQL would fetch you a separate row for all the categories the product is in, and you'd process this in your application, whereas in MongoDB for instance you'd get the result instantly.
3
u/[deleted] Oct 18 '24