View Single Post
 
Old March 23rd, 2007, 04:03 PM
harpua harpua is offline
Friend of Wrox
 
Join Date: Jun 2003
Location: Oklahoma City, Oklahoma, USA.
Posts: 249
Thanks: 0
Thanked 0 Times in 0 Posts
Default SQL_CALC_FOUND_ROWS

I was curious, which is the faster and best method when paginating data and why, using the SQL_CALC_FOUND_ROWS in your select statement then later calling the SELECT FOUND_ROWS() verses using a COUNT() to get total records.

Thank You
mike
__________________
Peace
Mike
http://www.eclecticpixel.com