Solution is to load only root categories and children of all unpacked nodes, set attributes raw_id_fields of customized admin classes to problematic slow or memory wasteful fields, customize ForeignKeyRawIdWidget to be richer than original but to stay as quick as the original widget.
This solution is laborious but then fast. For more than 100000 categories it would not help at all to reduce categories "a bit". On Mar 9, 6:43 pm, Dan <[email protected]> wrote: > 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. > -- 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.
