News for hackers. Stuff that matters.
Re:How to handle 1000s of concurrent users on a 360MB VPS by jacques_chester on Saturday May 28, 2011 @10:15PM (#2595740)
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.

There are no comments on this comment yet.