Hi, Thanks for your responses. DEBUG was set to True, and when I checked the memory, I didn't see any problems with paging. Based on the SQL logs, I eventually narrowed it down to the way one of my custom templatetags was displaying the categories in the left nav. I was calling category.translated_name() unnecessarily and I had some unnecessary for loops on the client side. After cleaning everything up, it's much faster!
Julie On Oct 19, 12:03 pm, Bruce Kroeze <[email protected]> wrote: > I suggest loading django-debug-toolbar, and seeing what the SQL queries are. > > > > On Sat, Oct 17, 2009 at 6:24 AM, Chris Moffitt <[email protected]> wrote: > > Julie, > > > The first thing I'd do is make sure that DEBUG=FALSE. > > > The second thing would be to check your memory and see if you're using it > > all up and doing a lot of paging. Is it possible that there is some other > > process that's sucking up memory? > > > The final thing, if you load a simple non-custom product into your store, > > does it take that long too? > > > - Chris > > > On Sat, Oct 17, 2009 at 12:12 AM, Julie Shum <[email protected]> wrote: > > >> Hello, > > >> I've set up my site, and I'm almost ready to deploy, but the > >> performance of Satchmo might prevent us from launching. Right now it > >> takes approximately 10 seconds to load a product page. The products on > >> the site are all mostly custom products with 1 to 4 option groups and > >> there are something like 15-30 options for each option group. > > >> I'm using lighttpd/fcgi with postgresql. I recently switched from > >> Apache with mod_wsgi and it seems to be slightly faster, but it's > >> still slow. Memcache is enabled. I've tried turning off Satchmo > >> logging, but it didn't seem to improve performance very much. > > >> I turned on sql logging after all of this to watch the queries and it > >> looks like there are thousands of queries hitting the db. These > >> queries take about 8-9 seconds to execute because there are so many. > > >> All of this is running on a 360 Linode VPS. > > >> Do you have any suggestions for how I can improve site performance? > >> Any help is greatly appreciated. > > >> Julie > > -- > Bruce Kroezehttp://www.ecomsmith.com > It's time to hammer your site into shape. --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
