hey rschilt,
thanks for the extensive answer.
here is my situation:
I am on my own root server, MYSQL is set up pretty good, caching on its own most of the queries if possible. No need optimizing MYSQl.
So basically havin eaccelerator in place (which adds another boost but only for the vhosts running on fastCGI and not those on suphp) I think my best bet is not a caching plugin that caches queries but rather one that caches to static html files like wp super cache. But even those static files are then served by apache, so the process consumes as much memory as without caching, except that the generation time should be less.
I hope that is right, at least that is how I undestood things so far.
dunno if this will keep the formatting, but I'll give it a try. This is an analysis of my current site. Most of the time is consumed in the start part... unfortunately I am not good enough to debug it further and find out whats taking 700ms...
Index Marker %Time %DB Time %DB Count Time DB Time DB Count Memory Output
(msec) (msec) (kb) lev(bytes)
0 Start 59 25 10 784.2 5.6 7 ?
1 plugins_loaded 5 0 0 64.9 0.0 0 30,665.6 1(0)
2 widgets_init 3 3 7 39.4 0.6 5 32,482.1 1(0)
3 init 6 0 0 78.5 0.0 0 33,835.7 1(0)
4 posts_selection 14 11 8 179.2 2.6 6 35,658.5 1(0)
5 wp_head 2 2 4 23.3 0.4 3 35,860.4 1(9875)
6 loop_start 1 11 4 18.9 2.4 3 36,027.5 1(14132)
7 get_footer 7 22 52 97.4 5.0 37 36,105.1 1(17567)
8 posts_selection 0 2 6 2.9 0.5 4 36,840.3 1(42435)
9 loop_start 2 25 8 31.7 5.7 6 36,849.8 1(42449)
10 Stop 36,897.7 1(48291)
Total 100 100 100 1,320.4 22.8 71