I'm wondering what the better solution is: Apache/PHP & PgSQL on one physical server with 100% performance (ie. 1200 MHz, 2GB RAM) or have Apache & PgSQL each on a server with half the performance (600MHz/1GB RAM each). I'm especially curious in the way long running queries affect the L2 cache performance in the mixed enviroment. What if Apache & PgSQL are fighting over the L2 cache making it's large size (in case of the new .13 micron CPU's from Intel) rather useless compared to the "dedicated solution", where each CPU runs only one application and can use the cache better? Maybe I'm missing something here completely, so I would appreciate any comments/suggestions. Is there a noticable performance gain in splitting the server in two? Thanks! -Zavier
