I have a new cluster site running on Magento that's on a development server that is made up of 2 x web servers and 1 x database server.
I have optimized the site in all areas I know (gzip, increasing php memory limits, increasing database memory limits etc) but sometimes the page loading gets stuck on 'waiting for xxx.xx.xx.xxx' (Chrome and other broswers, chrome just shows it that way). It can sit there for 40 + seconds, sometimes it just never loads and I close it in frustration.
What part of the page loading process is this hung at? Is it a server issue, database issue, platform issue?
I need to know where to start or whether to push the hosting provider about it.