Feeling Lucky
[#1274] - Improve JModelLegacy::_getListCount() performance on JDatabaseQuery objects
- Closed
- 5 Jul 2013
- Medium
- Build: master
- # 1274
- Diff
- mahagr:bug-modelcount
- Success default The Travis CI build passed Details
User tests: Successful: Unsuccessful:
Joomla currently uses unlimited query together with $db->getNumRows() to return total count. Unfortunately it has major performance penalty on large datasets, making queries very slow as @beat demonstrated in JAB13.
This pull request automatically optimizes all getListCount() calls to use COUNT(*) as long as JDatabaseQuery objects are used.
elinw
- comment
- 28 Jun 2013
infograf768
- 
garyamort
-
Great! Thanks Matias!