Matt Molyneaux said:
From personal experience, using FastCGI + Apache's
threaded worker
is "enough" memory wise. It might be a good intermediary step as it
won't require configuring a new httpd.
One of the reasons I use mod-suphp is that it means you don't need
mod-php which really cuts down on the size of each resident apache2
process. It's slightly slower to load php5-cgi, but hardly anyone will
notice the difference, especially if you use caching.
There's an article on the wiki about Apache tuning.
Ian