adam wrote:
I basically need virtual hosts, php and support for drupal's .htaccess URL-rewriting magic. SSL would be nice <snip> for phpMyAdmin
Nginx will do all of this easily (as would lighttpd, I'm sure) and be rock solid, using fastcgi or similar for php. URL-rewriting is handled via a few lines in the config file (see
here). At the risk of stating the obvious, Drupal can easily become pretty top heavy if one becomes a bit too enthusiastic with modules. Trimming the fat can really do wonders.
Is your database small enough to run cached ? If not, this will probably be your biggest issue.