I have over 1000 category's on the system and it would seem that just displaying the category tree using the cat_tree template tag is performing over 5000 query's. Does that sounds right, seems like a heck of a lot of query's, I guess I need to get the shop to reduce the category's a bit. Any other suggestions on how i can optimize this?
Thanks On Mar 7, 11:15 pm, John-Scott <[email protected]> wrote: > 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.
