Count vs DELETE Speed

[HoboTraveler]

Hi All,

When checking for duplicates between tables, is it quicker to check first, if the match exists in the table through a SELECT and then check the value of mysql_num_rows.

So, if mysql_num_rows > 0 then DELETE the record.

OR is it quicker to directly attempt a DELETE without checking if the match exists..

TIA

[eelixduppy]

The latter: directly try to delete them.

[coopster]

Exactly, and if you need to know if a row(s) was found so you can report success/failure to the user you can use mysql_affected_rows [php.net].