Hello Kevin, I just can tell you that I remember I have encountered similar issues (slowness) when I added product variations. As you can see in the satchmo_log the products get created really slow. But they get created. So watch the satchmo_log and do other work at this time. :-)
I can't tell you whats the reason for the slowdown, but encountered the same performance as you did. Good luck ionic On Wed, 2011-12-07 at 04:21 -0800, Caomhin wrote: > For obvious reason variations will always run slower than a straight > product, but I am finding it incredibly slow and was wondering if > anyone had suggestions on improving matters. > > 59787 www 18 48 0 6065M 5931M ucond 3 135:08 113.23% > httpd > > That's a long time to save a single product (and it's still going, and > will for quite some time) and becoming impractical. There are 4 > option groups with 4-9 items in each. Not all are selected at once, > but it is true they add up to a few hundred variants, however I feel I > should be getting better performance than I am so I worry I'm focusing > on the wrong areas. > > The database is Postgresql and looking at that process it is largely > sitting there idle awaiting transactions to finish. I'm taking this > as a mixed blessing since I've often assumed this was a database > bottleneck but if it's waiting a lot I guess I can assume the data is > flowing fairly nicely. > > Which brings it down to a data-processing issue and I'll admit I'm > going to be a bit stuck there. The create_variation code isn't > exactly lengthy so I'm not sure I'll find much gain really. Once that > process has finished I hope to try a few test but if anyone has > suggestions or results they'd like to see I'll try to run those tests > too. > > Cheers, > Kevin > -- 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.
