David, I do know that how the replacement parts site is presented isn't typical of most ecommerce site, but (on the other hand) it's certainly has one of the largest numbers of parts of any Satchmo site.
I did a lot of research on Postgres performance. I will say a custom Django CMS will have a flatter structure than a Satchmo site so certainly it will be faster. I would also say that I did a quite a bit of tweaking on the Postgres server itself and found a little bit of efforts goes a long way. I dug into my bookmarks and found the pages that came to my mind: http://wiki.postgresql.org/wiki/Tuning_Your_PostgreSQL_Server http://www.postgresql.org/docs/current/static/kernel-resources.html (this is probably the most important one). And this goes to what Arek was talking about: http://www.askthepony.com/blog/2011/07/django-and-postgresql-improving-the-performance-with-no-effort-and-no-code/ The problems I had with Memcache were on the checkout -- Satchmo (incorrectly, imho) used cache to store things on checkout and, if you look how memcache works, it doesn't guarantee that what you just put in the cache will be there if you ask for it right-away. For my setup, this causes an occasional problem with people checking out (a big deal, even occasionally). YMMV. On Wed, Mar 12, 2014 at 1:40 PM, David Unric <dunric...@gmail.com> wrote: > Thanks for your suggestions, guys. Glad to see this forum is not yet dead. > > @LZAntal I'm aware of these newbie mistakes but it's not this case. > Debugging mode is disabled, logging is tuned down to INFO level. Even > reducing to critical makes no difference. > > @Mike Hostetler Great answer, thanks.Nice site, btw. I'd bet Postgres > server has an optimal setup and there would be only marginal improvement if > any. I did tested performance even on powerful machine with postgresql > running locally. On the same hosting is already running pure Django based > CMS with ten times greater amount of items and is blazingly fast. > Good point is about indexes to tables. I did checked for the most > important models(Product, Category, ProductImage, Price, Discount ...) that > came to mind are already created. However if you look into template tags, > filters and some model's methods, you'll miss optimizations like > select_related or prefetch_related at places where it would be reasonable > and queries are needlessly doubled or even quadrupled. I see the only way > to rewrite them myself, however it looks like a quite consuming task I've > currently no resources to spend. > As a side note, your linked site has a fair response times, however try to > add much more details in category templates like basic price, discounted > price, stock amount, link for direct buy, short description, brand name, > promotion info etc. and you'll see what I am talking about. I had to reduce > number of displayed products from 16 to 12 per page to get some so-so > results. In a database is about 7 500 items only. > See what workarounds like category menu generator were already > accomplished - manual caching of category tree. > Memcached seems to bring some improvements after extensive requests become > handled but nothing drastical. > > @Arek I need to recheck if our provider does use or allow to use mentioned > poolers. Thanks for the tips anyway ! > > -- > 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 satchmo-users+unsubscr...@googlegroups.com. > To post to this group, send email to satchmo-users@googlegroups.com. > 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 satchmo-users+unsubscr...@googlegroups.com. To post to this group, send email to satchmo-users@googlegroups.com. Visit this group at http://groups.google.com/group/satchmo-users. For more options, visit https://groups.google.com/d/optout.
