hard20 pts · first answer countsperformance-testingdatabase-performancebottleneck-analysis

One page, 101 queries

A product list page runs 1 query for 100 products, then 1 query per product for its price: 101 queries per page. It is fine for one user but slow at 500 users. What is the fix?

A.Add more sleep() time between page loads in the testB.Increase the HTTP timeout to 60 seconds for this pageC.Use more load generators to send the trafficD.Fetch all prices in one query with a join or IN list

Discussion 0

Join free to post in the discussion.

One page, 101 queries

Discussion 0

Related questions