Hi,
We have a site (that's been live for more than 1 year) where, for multiple reasons, the integration was done and forced all master products to have at least 1 variant. The scenario is that variants represent "versions", so there's always a variant called "v-01", and some others will have "v-02".
(I'm told the through process is that this ensures some consistency in trusting that there is always a variant ID, rather than having some products with variants, others without and when a product would have a v2, we'd have to turn a "non-variant" product into one)
This all works well.
Recently we've identified a considerable amount of DB connections and we tied them to the GetVariantStockSum()
- The product Stock is requested
- Which triggers a request to GetVariantStockSum()
- And then called Services.Products.GetByProductIDs() - which eventually goes to the DB to fecth the AutoIDs
Despite being very fast, I wonder if there's something that could be done to avoid these repetitive calls to the DB. Maybe having some cache related to this. These are some of the stats we got from this implementation (notice the amount of requests per hour (for a relatively low volume traffic)
Best Regards,
Nuno Aguiar
