I developed and still support a Satchmo site with over 340k products in the database. The presentation is a little non-traditional but you can see it here: http://powerhousetoolparts.com
It runs on Django 1.3, Postgresql, and an older version of Satchmo. And, I had some performance problems. This is what I did: - move Postgres onto a different server. Yes I'm running virtual machines (now, in this case, Digital Ocean). Even with (or especially with) VPS servers, this is important. - Django puts few indexes on the tables. You may manually have to add indexes on what Django's ORM is querying on. - Tune your Postgres server. The default Postgres package on Ubuntu (for example) is hardly tuned for a production environment. You need to go experiment with different settings. I can't find the exact guide I used but here is a decent page to get started on http://samiux.wordpress.com/2009/07/26/howto-performance-tuning-for-postgresql-on-ubuntudebian/ - caching -- this is important but it's the last step I'd work on. I've found using memcache to be problematic with Satchmo, specifically. Now I used the database cache . . .yes, I cache my Postgres Queries in a Postgres table itself. There are other options, of course, but after I tuned my Postgresql server I found that doing the database cache was sufficient. Let me know how it works out for you. Feel free to contact me off list if you have more questions. On Tue, Mar 11, 2014 at 9:27 AM, David Unric <[email protected]> wrote: > Hello, > > hope I'm not alone who fights with higher response times of deployed > Satchmo application. > Current Satchmo-tip running on pro hosting with recent mod-wsgi, memcached > on top of recent nginx. Django is of 1.4.10 version, psycopg2 2.5.2 for > connection to Postgresql. > > I've already investigated most of response time (> 95%) is spent in > database queries, so there is the bottleneck. I've further discovered views > code of Satchmo is relatively ok but templates tags and filters are > painfully suboptimal, like `base_price', `discount_price', `sale'. Or some > of model's path retrieval methods which instead of working with model > attributes do invoke urlresolvers. > > I'm asking if there is some fork of Sacthmo with some of mentioned > optimization already done. I can push some of my code fixes and > enhancements in return. > > Any hints ? > > Thanks. > > -- > You received this message because you are subscribed to the Google Groups > "Satchmo users" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to [email protected]. > To post to this group, send email to [email protected]. > Visit this group at http://groups.google.com/group/satchmo-users. > For more options, visit https://groups.google.com/d/optout. > -- Mike Hostetler SquarePeg Systems http://www.squarepegsystems.com -- You received this message because you are subscribed to the Google Groups "Satchmo users" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at http://groups.google.com/group/satchmo-users. For more options, visit https://groups.google.com/d/optout.
