[development] faster pagination with SQL_CALC_FOUND_ROWS

karoly at negyesi.net karoly at negyesi.net
Sat Aug 12 17:49:50 UTC 2006


We discussed dropping MySQL 3.x and this would be a good reason.

We would need to move pager_query to database.*.inc.

However implementation -- as pager_query now stands -- is a bit problematic at first glance because the number of total rows is used in calculating the offset...

Regards

NK

Ps. Google on SQL_CALC_FOUND_ROWS  drupal and find http://drupal.org/node/38297 


More information about the development mailing list