Joy, so some clever sods decided that databases aren’t really that expensive and that it’s perfectly fine to make lots of queries against tables for every little web page they write.

However, when does the programmer think about their little nested SELECT statement and the 20,000 rows of data they get back to generate a little 30Kb web page?

Err, do the math people! If you’re going to talk to a database, then ask for what you need not what you think you might want.

If you’re requiring that much data for each page, then look at your design – it sounds like you might have chosen the wrong design.