[RESOLVED] which query is better?

[Zpixel]

in order to get the number of results, which query is better: faster and less memory consumer

1)
$result=mysql_query("SELECT count(*) FROM table1");
$row=mysql_fetch_array($result);
$numOf results=$row[0];

2)
$result=mysql_query("SELECT * FROM table1");
$numOf results=mysql_num_rows($result);

[dagon]

1 but its not the only option

[Zpixel]

thank you. another question.

How can i check for the time each query takes? i'm using easyphp under windows. the query bellow:

EXPLAIN EXTENDED SELECT * FROM feeds WHERE 1

returns this result:

id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE feeds ALL NULL NULL NULL NULL 252

this query doesn't show the time elapsed. how should i check the time?

[dagon]

start a timer, run query end timer. As for easyphp, never used it.

[Zpixel]

good idea. not any easier way?