Indeed, pushing MySQL onto a different VPS in the same network basically halved page generation times for my sites.
This is partly because when a table contains a TEXT field, MySQL performs all joins against that table on disk, regardless of what fields you're selecting or joining on.
Which is a problem for, oh, I dunno, every PHP blog engine / bulletin board / CMS ever.
This is partly because when a table contains a TEXT field, MySQL performs all joins against that table on disk, regardless of what fields you're selecting or joining on.
Which is a problem for, oh, I dunno, every PHP blog engine / bulletin board / CMS ever.