Centric CRM 4.1 (Stable and Released)
Core Team
Assignment
Priority:
Assigned To:
unassigned
Ticket # 163
This ticket is open
Severity:
Important
Category:
Functionality
Entered by:
Alessandro Forghieri
9/20/2007, 11:09 AM
Last modified:
Alessandro Forghieri
9/20/2007, 11:09 AM
Description
Displaying a quote on a 900 item catalog - with each product having an option list of four items - clocks in at above 90 seconds.
Dropping all the product options restores timing to a saner 1 second or so.
The reason (as we were able to diagnose it) is that the Quotes.do?command=Details action causes a ProductList to be built (this happens even before it is known wether the quote has products). The ProductList, in turn, scans th option map (one line at a time) and fills in the option values. At the end of this the entire catalog has been loaded performing an inordinate amount of queries (by looking at the code, I'd say it's one query per optioned item).
Until this is fixed, quotes on large catalogs with options are not feasible.
Solution
A solution hasn't been entered
File Attachments
There are no file attachments
Ticket Activity
| Date | Event |
|---|---|
| Alessandro Forghieri 9/20/2007, 11:09 AM | [ Ticket Opened ] |
| Alessandro Forghieri 9/20/2007, 11:09 AM | [ Ticket is unassigned ] |
| Alessandro Forghieri 9/20/2007, 11:09 AM | [ Severity set to Important ] |
| Distribution List |
|---|
| Alessandro F. |