Centaurus writes :

I believe the $sth->execute method returns the number of rows or -1 if no rows affected. You may also want to try the $sth->rows method.

These methods are unreliable in some databases -- they may only return an accurate count if all the rows have been read.