For large tables including the count can have very large performance implications:
SELECT COUNT(id) FROM something; -- Runtime: 5507.556ms
SELECT * FROM something LIMIT 50 OFFSET 0; -- Runtime: 0.193 ms
It would be great to be able to send in an option to disable the count entirely.
For large tables including the count can have very large performance implications:
It would be great to be able to send in an option to disable the count entirely.