We have a product that has 8 possible slots on it of which each of those slots could be any 10 different items.
Everything seems to work up to about 5 option groups containing 10 items per group, but once we try to add a 6th option group, apache/mod_wsgi and/or the devserver skyrocket their usage and never spit out any real error, nor does mysql report anything.
STEPS TO REPRODUCE:
(Using Django 1.1.2 and satchmo trunk)
Create a clean store, create a single product. Then create 10 optiongroups, containing 10 option items in each and then using the configurable product, assign 6 or more optiongroups to the one product and then try to view the product on the live site.
Please let me know if attaching the stack trace dumps would be of any assistance. I am happy to help debug this and hopefully fix this issue, but I'm not sure exactly where to start.