Topic: about 40 queries / page load
Given an e-commerce website i'd like to allow users to customize products. Basically, when they want to customize a t-shirt for e.g. i was thinking to duplicate the t-shirt product so that they can sell it later(a product has_many designs - the design model contains the actual customized attributes like the graphic added on the t-shirt and the coordinates).
My concern is that when i duplicate the product too many queries are executed. About 40 mixed queries(insert/update/select).
Question: Are 40 queries/page load too many?
P.S. There are about 40 queries because the product model also has variants, option values, properties, etc.
Last edited by suciuvlad (2012-09-30 13:05:12)