Webfaction unfortunately really doesn't give you enough power to run Satchmo "for real". Sorry. There are several Satchmo queries which will hammer a store with 4300 products.
Move to Slicehost. Barely more money, much more performance, much better interface. On Wed, Jun 9, 2010 at 10:13 AM, lzantal <[email protected]> wrote: > 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]<satchmo-users%[email protected]> > . > For more options, visit this group at > http://groups.google.com/group/satchmo-users?hl=en. > -- Bruce Kroeze http://www.ecomsmith.com It's time to hammer your site into shape. -- 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.
