SQL - vs - PHP count

[Suchy]

Which method causes less stress on the MySQL server.

 

The SQL way:

$query = "SELECT COUNT(person_id) AS counter FROM video WHERE person_id = 1 AND public_account = 1";
$result = mysql_query($query);
$row = mysql_fetch_array($result);
$counter = $row['counter'];

 

or the PHP way:

$query = "SELECT person_id FROM video WHERE person_id = 1 AND public_account = 1";
$result = mysql_query($query);
$counter = mysql_num_rows($result);

 

All I need is to display amount of videos each person has.

[kickstart]

Hi

 

The SQL way should.

 

If you want all the peoples counts then:-

 

$query = "SELECT person_id, COUNT(person_id) AS counter FROM video WHERE public_account = 1 GROUP BY person_id";

 

All the best

 

Keith