21.01.2016, 22:33
^ What he said.
Also if you only want to count something you should use the COUNT() aggregate function. Sending over the entire resultset (possibly containing hundreds of rows) is more resource intensive and therefore slower. The COUNT() function will always give 1 row with 1 column with 1 value that contains the number of rows. Even if the count is 0.
Also if you only want to count something you should use the COUNT() aggregate function. Sending over the entire resultset (possibly containing hundreds of rows) is more resource intensive and therefore slower. The COUNT() function will always give 1 row with 1 column with 1 value that contains the number of rows. Even if the count is 0.