speed: passing objects vs. multiple mysql queries

[antiemptyv]

is it more efficient to get all the information you can about a user, say, and create an object and pass the information around like that while you're outputting the user information or pull the information from the database as you use it?

[fenway]

If you mean pulling individual fields vs. an entire record, I think it's obvious that the latter is better.  Of course, for large recordsets, you may not need all of the fields.