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.
