Re: Slow satchmo
How many req/sec can you achieve at the moment with everything tuned up for production? How many other customizations have you made besides the one you mentioned? I'm interested because my friend's company is running an online store on Magento and their performance really sucks so I'd just like to rub it in their face, lol. Erik On 02.10.2008, at 12:29, Jordan Dimov wrote: > > 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 satchmo-users@googlegroups.com 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 -~--~~~~--~~--~--~---
Re: Slow satchmo
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 satchmo-users@googlegroups.com 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 -~--~~~~--~~--~--~---
Re: Slow satchmo
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 satchmo-users@googlegroups.com 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 -~--~~~~--~~--~--~---
Re: Slow satchmo
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 satchmo-users@googlegroups.com 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 -~--~~~~--~~--~--~---
Re: Slow satchmo
2008/9/30 geezer <[EMAIL PROTECTED]>: > > hi, i am interested in setting up a satchmo store, how did you import > 2000 products?, does satchmo have an easy way to do this?, any answer > would be greatly appreciated, thanks. There's also an import/export function: /product/inventory/export/ And obviously you can add manually to the database. -- Alessandro Ronchi Skype: aronchi http://www.alessandroronchi.net SOASI Soc.Coop. - www.soasi.com Sviluppo Software e Sistemi Open Source Sede: Via Poggiali 2/bis, 47100 Forlì (FC) Tel.: +39 0543 798985 - Fax: +39 0543 579928 Rispetta l'ambiente: se non ti è necessario, non stampare questa mail --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups "Satchmo users" group. To post to this group, send email to satchmo-users@googlegroups.com 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 -~--~~~~--~~--~--~---
Re: Slow satchmo
hi, i am interested in setting up a satchmo store, how did you import 2000 products?, does satchmo have an easy way to do this?, any answer would be greatly appreciated, thanks. On Sep 30, 4: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 satchmo-users@googlegroups.com 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 -~--~~~~--~~--~--~---
RE: Slow satchmo
Try Django-Logging, available at http://code.google.com/p/django-logging/wiki/Overview . If activated in settings.py as middleware it gives you for any page at the bottom a detailed overview about the queries running and how much time spent on each one. This should be a good starting point for further analysis. If it is helpful for you I suggest to write a ticket and include it as standard option in settings.py. Rgds g -Original Message- From: satchmo-users@googlegroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Jordan Dimov Sent: Tuesday, September 30, 2008 10:11 PM To: Satchmo users Subject: Slow satchmo 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 satchmo-users@googlegroups.com 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 -~--~~~~--~~--~--~---
