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)

Re: about 40 queries / page load

You have to reduce number of queries there. Use eager loading and try to include relative data to increase overall performance.

Offshore Software Company
Top Software Company

Last edited by Kenank (2012-10-22 08:21:12)