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" <[EMAIL PROTECTED]> 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 <[EMAIL PROTECTED]> 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
