I'll go through the source over the weekend and try to find and fix some slow parts.
For now, it might improve the speed if the MySQL server would be located on a different machine than the Apache. I think that could be done without too much trouble, and without security problems for Bomis.
Magnus
wikitech-l@lists.wikimedia.org