[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
>
> SELECT FOUND_ROWS();

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

OK.

Thanks!



More information about the thelist mailing list