2 replies to this topic

[webcodez]

Hi,

Was wondering whether that's a big difference in the mysql resources usage of using multiple mysql queries ( one per field ) or just 1 mysql query selecting all the fields.

Like, would there be a big difference in using either:

SELECT field1,field2,field3 FROM members WHERE id = 1

or

SELECT field1 FROM members WHERE id = 1
SELECT field2 FROM members WHERE id = 1
SELECT field3 FROM members WHERE id = 1

The reason why I'd want to use the 2nd example is as for a function I created to do this (like: getMemberinfo("fieldname")).

Thanks in advance!

Cheers.

[WingedPanther]

It depends somewhat on the query, and the details of what you're doing. If you're actually going to get all three fields, I'd do it as a single query (lower network traffic between PHP and MySQL).

[webcodez]

Allright, that's all I needed to know, thanks =].