Actually, it's not so strange. When you're just listing products in the admin, it's just iterating over a Product.objects.all().
Filtering by category via Satchmo can be pretty crazy, especially depending on how many categories you have. It's been a while since I've dug into the code, but IIRC it basically takes all categories and then does a Product.objects.filter(categories__in=huge_list_of_categories), although I believe there are a lot of other queries involved before it gets to the final list of categories and filters the products. Try enabling logging in psql for all queries to see if it's one query taking too long or thousands of smaller queries taking too long. There have been other complaints on this list once the number of products and categories reaches a certain size...so there may be some room for optimizing Satchmo's code or at least clearly documenting the performance issues. Anyway, I wouldn't move off uWSGI just yet. Your app is most likely database-bound, so would need to rule that out first before suspecting another piece of the stack. Good luck, John-Scott -- 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.
