| Stupid
Query Tricks |
|
|
|
|
|
|
|
|
|
|
|
| • | Use SQL_CALC_ROWS and |
|||||||||
| FOUND_ROWS() rather than double- |
||||||||||
| queries: |
||||||||||
| – | SELECT
… LIMIT N, M |
|||||||||
| – | SELECT
COUNT(*) |
|||||||||
| • | Instead: |
|||||||||
| – | SELECT
… LIMIT N, M |
|||||||||
| – | SELECT
FOUND_ROWS() |
|||||||||
| • | Requires far less overhead on MySQL |
|||||||||
| Copyright 2003, Jeremy Zawodny |