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-production.html

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 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 .

--
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 .



--
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 .

--
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.

Reply via email to