What is the fastest way to determine if a query has not returned any data?
I am currently using im MySQL: SELECT count(var) from table ...;
The result is tested (in php) for a zero result:
Performance is becoming an issue as the table grows larger.
Is there a faster way to do this?