NYCPHP Meetup

[Brent Baisley]

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
>
>
> _______________________________________________
> New York PHP Community Talk Mailing List
> http://lists.nyphp.org/mailman/listinfo/talk
>
> NYPHPCon 2006 Presentations Online
> http://www.nyphpcon.com
>
> Show Your Participation in New York PHP
> http://www.nyphp.org/show_participation.php
>