[thelist] SQL Loser

Fred Jones fredthejonester at gmail.com
Tue Aug 12 08:41:53 CDT 2008

>> In order to get the number of results, however,
>> in order to be able to page the results, ...
> use SQL_CALC_FOUND_ROWS in the outer query and then follow with

Oh, great--never knew about that.

> by the way you might want to change your joins to INNER JOINs
> i'm pretty sure they'll produce the same results, and might run faster



More information about the thelist mailing list