In the last episode (Sep 17), Miguel Cardenas said:
> I have a technical doubt, very simple but not mentioned in the manual...
> 
> What happens if I call mysql_free_result() after performing a query
> but without doing mysql_fetch_row() ???
> 
> It may sound strange, but just need to know if a data row exists more
> than the data itself...

A faster way would be to run a "SELECT count(*) WHERE ..." query, and
check the result.  Since you are not selecting any data, mysql is more
likely to be able to use index lookups to speed the query up.

-- 
        Dan Nelson
        [EMAIL PROTECTED]

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]

Reply via email to