Oook, my bad. I guess I'm loading a list of several hundred categories on each view, to display the category menu. I cached the whole category menu template fragment, and the speed-up was impressive.
~ Jordan On Oct 2, 12:05 pm, Jordan Dimov <[EMAIL PROTECTED]> wrote: > I already have caching. I use memcached. It doesn't seem to speed up > anything at all. I get same results with or without it. > > Google Analytics is not the problem -- I use it on all my sites, and > the overhead is insignificant. > > The REAL problem is that when I turn on logging, I see more than 1000 > (that's one thousand) SQL queries just to display 10 products on my > index page. To display 50 products, Satchmo generates more than 1500 > SQL SELECTs. > > Pretty sucky, if you ask me. > > ~ Jordan > > On Oct 2, 2:56 am, boonez <[EMAIL PROTECTED]> wrote: > > > > > Hi, > > > Slow store. This is what I had to do....... > > > 1. Turn on django caching.http://docs.djangoproject.com/en/dev/topics/cache/ > > 2. Disable Google Analytics in the edit site settings link, (since > > google analytics sets cookies everytime) http://yourstore.com/settings/ > > (Google Options) > > > Voila. > > > Mark > > > On Sep 30, 1:10 pm, Jordan Dimov <[EMAIL PROTECTED]> wrote: > > > > So I've spent the last month or so setting up a Satchmo store. > > > Finally I got everything running. I have a fairly modest inventory > > > base of about 2000 products, spread in 200 categories. The store > > > seems to be running pretty slow though -- it takes 3 to 5 seconds to > > > load any given page. I'm using SVN Satchmo from a couple of weeks > > > back, Django 1.0, Apache2 - worker, and mod_wsgi. I also changed the > > > Satchmo cache backend from file to memcached, but it doesn't seem to > > > speed it up any. Is there something I'm missing? > > > > I have several other Django sites running on the same box, and their > > > performance is great. Only the Satchmo store is slow. > > > > ~ Jordan --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
