I found this very nice feature SQL_CALC_FOUND_ROWS to use if you want to get an idea of how many records were found, even though you’re using limit. I was delighted to find this. Before I was using a count query which was always very annoying to build and it went against all my instincts;)
Is there a catch? Any reason why not to use this feature. It does slow down the query some, but i guess that’s to be expected.
Thanks for any comments on this.