i think i'm facing a similar problem. we have only about 5,000 products. almost all are configurable products. i've been looking through the code and through the posts here, and as far as i can tell there're a lot of places where having many configurable products results in very large database queries. in our case accessing the products variation manager with our 5000 products results in about 17,000 database queries.
the only solution i've seen suggested on the list is to use custom products in this case. at this point i don't think that this will work for us so i'm hoping to improve things while continuing to use configurable products. i'm thinking of omitting from the admin if possible the individual product variations pages that have the javascript powered lists of options and trying to optimize the product variations manager page and the queries associated with it. but i've not implemented this, so not entirely sure this will work. On Tue, Mar 16, 2010 at 11:21 AM, Stuart Laughlin <[email protected]>wrote: > Hello All -- > > When I'm in satchmo admin and trying to change an existing Product > Variation or Configurable Product, my browser freezes up and I get a > "Warning: Unresponsive script" dialog. > > I have tracked down the cause of this, and it relates to the > js_make_select_readonly template tag that is being used in > "admin/product/change_form.html". The js output by this template tag > loops through all the children of the passed-in html select searching > for the currently selected item. This works fine in most cases, but it > is too inefficient when your select has 20,000+ items in it, as my > Product select does. (As an aside, I wonder how many folks out there > are using satchmo with a product catalog of this magnitude?) > > Anyway, my quick fix is to simply remove the call to the > js_make_select_readonly template tag in the > "admin/product/change_form.html" template. This makes the product > admin slightly less foolproof, but I can live with that for now. > > I will probably try to improve the js_make_select_readonly templatetag > at some point -- making it more efficient so that it can handle > selects w/ lots of items -- and if that happens I'll be sure to submit > a patch. In the mean time, should I submit a ticket or anything like > that? Or does anyone have any comments/thoughts? > > > Regards, > > --Stuart > > -- > 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]<satchmo-users%[email protected]> > . > For more options, visit this group at > http://groups.google.com/group/satchmo-users?hl=en. > > -- Aleksandr Vladimirskiy -- 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.
