NYCPHP Meetup

[Cliff Hirsch]

This is brilliant. But read the notes:

http://dev.mysql.com/doc/refman/5.0/en/information-functions.html

On 10/18/07 5:08 PM, "Brent Baisley" <brenttech at gmail.com> wrote:

> You don't need to do an extra count query. If you are using MySQL,
> just add SQL_CALC_FOUND_ROWS to your select query.
> SELECT SQL_CALC_FOUND_ROWS * FROM ...
> 
> You can then run SELECT FOUND_ROWS() to get the total rows without any
> limits. It's still 2 queries, but the second one is essentially free.
> 
> 
> On 10/18/07, Cliff Hirsch <cliff at pinestream.com> wrote:
>>> 1) TWO-QUERY APPROACH
>>> on every page view:
>> FAILSAFE. An extra count query, but no worries.
>> 
>>> 3) ONE QUERY, CACHE EVERYTHING
>> What if the count changes between pages view? What if there are millions of
>> records -- awfully big fetch. What if you change the application down the
>> road, which creates the potential for changes in row count between views?
>> Lot's of state info to think about....
>> 
>> My two cents...
>> Cliff