Posted by j0k3z on November 18, 2010 at 11:39pm
This has been an ongoing problem for my site that I have still not figured out.
I am running Mercury but my site can barely keep up with just 20 users. The site always comes to a halt. Even with just 1 or 2 users the site is very slow. I am not even sure where to begin diagnosing the issue as I am not much of a server admin. I know I have some slow database queries but even on pages with no major queries the site just hangs for a long time. Im getting really frustrated because my shared server was 100x faster then my current Mercury setup with the same queries and everything.
Comments
Profiling?
I assume you've got devel enabled and have compared query time to page execution time? If the latter is much greater, profiling with XHProf or Xdebug + KCachegrind can be pretty helpful. I managed to narrow down about 90% of my 45 second (!) page load times to one rogue module.