What is Faster? (1 reply)

This Comment will be submitted for moderation and will not be accessible to other users until it has been approved.
Submitted by programmer on Fri, 08/15/2008 - 08:41.
::

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...?

Post Comment

  • You can enable syntax highlighting of source code with the following tags: <code>, <blockcode>, <c>, <cpp>, <drupal5>, <drupal6>, <java>, <javascript>, <php>, <python>, <ruby>. Beside the tag style "<foo>" it is also possible to use "[foo]". PHP source code can also be enclosed in <?php ... ?> or <% ... %>.