Hi All,
When I enter a discount code at checkout it takes over a minute to go
to the next step and it times out.
The satchmo store has 4300 products in it.
I just received and email from webfaction that they killed my mysql
query because it was running way too long.
Here is the query that was running:
Query: SELECT `product_productpricelookup`.`productslug` FROM
`product_productpricelookup` WHERE
(`product_productpricelookup`.`discountable` = 1 AND
`product_productpricelookup`.`productslug` IN (SELECT U0.`slug` FROM
`product_product` U0 INNER JOIN `product_discount_validProducts` U1 ON
(U0.`id` = U1.`product_id`) WHERE U1.`discount_id` = 2 ) AND
`product_productpricelookup`.`productslug` IN (SELECT U2.`slug` FROM
`shop_cartitem` U0 INNER JOIN `product_product` U2 ON (U0.`product_id`
= U2.`id`) WHERE U0.`cart_id` = 470 ))
Did anyone had this kind of issue with using discount code?
Any help would be greatly appreciated
Thank you
lzantal
--
You received this message because you are subscribed to the Google Groups "Satchmo
users" group.
To post to this group, send email to [email protected].
To unsubscribe from this group, send email to
[email protected].
For more options, visit this group at
http://groups.google.com/group/satchmo-users?hl=en.
