MySQL Performance: MySQL => SQL_CALC_FOUND

SQL_CALC_FOUND_ROWS [message #157]

Mon, 11 September 2006 10:23

sbazemore
Messages: 4
Registered: August 2006
Location: Charlotte, North Carolina

Junior Member

I use SQL_CALC_FOUND_ROWS on some of my queries to create my paging for my site. It has worked fine for a few months and all of a sudden it quit working.

It doesn't matter how simple the query it alway's returns 1.

I have a table with ~(40,000) rows and I run a query like:

SELECT SQL_CALC_FOUND_ROWS media_id FROM media ORDER BY media_id DESC LIMIT 0, 15;

SELECT FOUND_ROWS(); returns 1.

Nothing has changed in the code, and even running this through MySQL command line returns the same result.

Any suggestion?

Report message to a moderator