Re: FN-FORUM: Choosing the next record in MySQL DB

date posted 14th May 2008 15:16

On Wednesday 14 May 2008 16:41:44 Tom Wilson wrote:

> I'm taking that as agreement that 1 is better than 3 separate.

Hah! I'm afraid you signed up for the full half hour. My answer is
whatever's more maintainable is better. In this case the "composite"
query is still fairly short, and saves a load of cruft around it (i.e. only
one call to the engine, only one result row, etc).

But if you had three long and complicated SELECTs to do I'd rather
keep them separate rather than bundle them up into one multi-line
monster.