View Issue Details

IDProjectCategoryView StatusLast Update
0000396XMB1New Featurespublic2010-12-07 15:42
ReportermiqrogrooveAssigned To 
PrioritynormalSeverityfeatureReproducibilityhave not tried
Status newResolutionopen 
Product Version 
Target VersionFixed in Version 
Summary0000396: Optimization: SQL_CALC_FOUND_ROWS
DescriptionInteresting article here. I learned something new about MySQL.

http://www.arraystudio.com/as-workshop/mysql-get-total-number-of-rows-when-using-limit.html

This other article shows some pitfalls in that technique

http://www.mysqlperformanceblog.com/2007/08/28/to-sql_calc_found_rows-or-not-to-sql_calc_found_rows/
TagsNo tags attached.
MySQL Version
PHP Version
Web Server
Browser
Flags
Original Reporter
SVN Revision

Activities

There are no notes attached to this issue.

Issue History

Date Modified Username Field Change
2010-12-07 15:26 miqrogroove New Issue
2010-12-07 15:42 miqrogroove Description Updated