issues with Nginx + Passenger Production setup - Loading time/request time delay

Posted by Dani Cela on Server Fault See other posts from Server Fault or by Dani Cela
Published on 2012-09-18T20:28:54Z Indexed on 2012/09/18 21:40 UTC
Read the original article Hit count: 280

having a bit of an issue relating to request time. I have NGINX as a proxy server for a ruby on rails app running passenger. I also have a postgresql database server which is running on its own VM separate from my nginx/application server. My issue is that when I try and access my products page which does a lot of database queries, my query takes maybe 3-4 seconds. The second I flood the web server with requests, i will choke out the web server and have requests take almost 20-30 seconds to process. The rails server and database server do not crash, and the usage is not that high. Each server has more than enough memory, even cpu usage on the rails server isn't more than 85%, albeit thats high but its not maxing it out.

Is my problem related to my nginx proxy server?

I dont really know how to fully explain this so if you have a question please ask it and I can clarify what I mean.

EDIT: to see exactly what i mean relating to the database query, see

http://207.245.4.215/products

© Server Fault or respective owner

Related posts about nginx

Related posts about postgresql