Well. All brands. Got thousands of products distributed in about 20 brands. What's the fastest way? Is it going to be slow because the brands are serialized into the productDynamicFields column?
No, they're also indexed. It's slow because you'll need to get all the products to count them, even though they're not being used. The process would be
Get all brands
For each brand...
Get all products by brand
Count the products
Obviously it would be much quicker with a dedicated function, but that doesn't exist right now.
There's not a built in way, but yes it can be done.
What's the context? Do you need to do just one or many? This would affect the method.
Well. All brands. Got thousands of products distributed in about 20 brands. What's the fastest way? Is it going to be slow because the brands are serialized into the productDynamicFields column?
No, they're also indexed. It's slow because you'll need to get all the products to count them, even though they're not being used. The process would be
Obviously it would be much quicker with a dedicated function, but that doesn't exist right now.