I actually wrote a post on another forum regarding the SQL_CALC_FOUND_ROWS if anybody is interested. That can be viewed here. It really is crucial, Randy, if you're going to be using the pagination as listed on Pixel2Life then your database will end up flat on its back with the load. Of course, COUNT(*) is another way to achieve this as it will get the data straight from the attached table information.