The strange thing is its when doing a filter by a category showing all the products in admin doesnt have a problem.
I will try to VACUM the database and if that doesnt help i will try using something other than uWSGI I guess On Mar 7, 1:56 pm, Alex Robbins <[email protected]> wrote: > Yeah, that definitely wouldn't break a listing without images. > Alex > > On Mon, Mar 7, 2011 at 7:42 AM, Mike Hostetler > > > > > > > > <[email protected]> wrote: > > I think that's understandable on product pages, but what about the Admin > > list? I can get the full list of products, but when I click on a Category > > to filter out, it doesn't show up. That seems to me to be a query problem. > > > On Mon, Mar 7, 2011 at 7:35 AM, Alex Robbins <[email protected]> > > wrote: > > >> I've had a problem a couple times where the page will error out when > >> showing products because of all the thumbnailing that has to happen. > >> Obviously this only happens the first couple times, but if you have > >> 30k products, maybe you are viewing a subset that hasn't ever been > >> viewed before, and the thumbnailing is making the request take too > >> long. You won't get any errors in the logs because nothing actually > >> broke, just took too long. > > >> Alex > > >> On Sun, Mar 6, 2011 at 2:57 PM, Mike Hostetler > >> <[email protected]> wrote: > >> > I have a similar setup (Apache/wsgi and PostgreSQL) only I have >300,000 > >> > products (!!!) > >> > So I just tried it and it takes a while, but I do get a response back. > >> > Have > >> > run ANALYZE or VACUUM on your tables? With 40,000 products, you may > >> > need > >> > to. That said, it seems that there is an index missing on the Satchmo > >> > tables. > > >> > On Sun, Mar 6, 2011 at 12:37 PM, Dan <[email protected]> wrote: > > >> >> Using satchmo with Nginx, uWsgi and postgresql on a linode slice and > >> >> getting 504 gateway error when trying to filter products by a certain > >> >> category in admin and front end. > > >> >> There are about 40,000 products on the system. > > >> >> nginx logs says: > > >> >> "upstream timed out (110: Connection timed out) while reading response > >> >> header from upstream" > > >> >> No errors from postgres or uwsgi, thier process's still seem to be > >> >> runing > > >> >> listing all products in admin without category filters works ok. > > >> >> Any ideas about this issue? > > >> >> -- > >> >> 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. > > >> > -- > >> > Mike Hostetler > >> > SquarePeg Systems > >> >http://www.squarepegsystems.com > > >> > -- > >> > 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. > > >> -- > >> 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. > > > -- > > Mike Hostetler > > SquarePeg Systems > >http://www.squarepegsystems.com > > > -- > > 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. -- 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.
