faster pagination with SQL_CALC_FOUND_ROWS
12 Aug
2006
12 Aug
'06
1:04 p.m.
Hi, This might be interesting to try for those working on MySQL optimizations in Drupal: http://www.arraystudio.com/as-workshop/mysql-get-total-number-of-rows-when-u... Gabor
12 Aug
12 Aug
7:49 p.m.
New subject: [development] faster pagination with SQL_CALC_FOUND_ROWS
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
7253
Age (days ago)
7253
Last active (days ago)
1 comments
2 participants
participants (2)
-
Gabor Hojtsy -
karoly＠negyesi.net