Communities for your favorite technologies. Explore all Collectives
Now available on Stack Overflow for Teams! AI features where you work: search, IDE, and chat.
Ask questions, find answers and collaborate at work with Stack Overflow for Teams. Explore Teams
Find centralized, trusted content and collaborate around the technologies you use most.
Teams
Q&A for work
Connect and share knowledge within a single location that is structured and easy to search.
Get early access and see previews of new features.
I don't really think any testing is needed.
Doing the COUNT in the SQL query
Sends only one row of data back the to client (instead of every row)
Lets SQL do the count for you which is likely always going to be faster thenthan PHP.
Lets SQL do the count for you which is likely always going to be faster then PHP.
Lets SQL do the count for you which is likely always going to be faster than PHP.