|
Jason
| Joined | Mar 2013 | | Posts | 102 | | Thanked | 8 times |
|
The two pages were so slow they have become unusable. We need some time to rework the query and optimize so it is usable again.
For anyone curious, the query itself is fast, the issue is the subquery that has to compare the lowest price or lowest ever price seen with other stores carrying the same product. For example, if Amazon sells a CPU for $100 regularly, and another store sells it for $400 then drops the price to $200, we would claim 50% off, but we know even at 50% off its still a bad price even if its the lowest price ever seen at this store. The subquery eliminates bad price drops like that from the results. Unfortunately the number of stores and products in the system has grown to the point where this went from sub-2 second query to something that has been taking a minute.
I will readd the two pages back soon as we can. |
United States