Hi Bruce, Thank you again for the tip. I finished porting the site to slicehost(384MB slice) with nginx +fastcgi+mysql. It works great. The longest query time for discount code went all the way down to 20sec!:) Now i just need to figure out the memory usage. It is using around 190MB right now.
Thank you again lzantal On Jun 10, 8:08 pm, lzantal <[email protected]> wrote: > Hi Bruce, > > That os a great article. Thank you very much for the link! > > lzantal > > On Jun 10, 2010, at 10:22, Bruce Kroeze <[email protected]> wrote: > > >http://coderseye.com/2010/how-to-run-sandboxed-django-sites-in-produc... > > > Actually, these days I use buildout for all my Satchmo sites, but > > that is still a good reference for the base installation stuff. > > > On Thu, Jun 10, 2010 at 8:01 AM, lzantal <[email protected]> wrote: > > Hi Bruce, > > > Thank you for the heads up. > > I will get a 256MB slice, I have been thinking about switching for > > awhile anyway so I guess I got my reason. > > Is there any best practices for setting up a slice for satchmo? > > Eg: nginx-apache2-mod_wsgi etc? > > > Thank you for your help > > > lzantal > > > On Jun 9, 2010, at 19:30, Bruce Kroeze <[email protected]> wrote: > > >> 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] > >> . > >> For more options, visit this group > >> athttp://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 > >> athttp://groups.google.com/group/satchmo-users?hl=en > >> . > > > -- > > 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 > > athttp://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 > > athttp://groups.google.com/group/satchmo-users?hl=en > > . -- 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.
