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.
