Faster Result.

Building A friend list

[fever_1o5]

I was wondering wich result is better for my friend list...

If I have 1.000.000 rows in a table and need to select multiple rows from it for example

select * from friend where login='fever' will have 200 results

or is it better that I put in an array and split it in php

for example ¦me¦you¦fever¦webmaster¦world¦

select * from friend where login='fever' will have 1 results

$friends=split("\¦",$qeuryresults);

and loop them out...?

[eeek]

While the splitting out method will work I'd go with the one row each. It'll be better for possible new features in the future.