Summary

The query generated by the front-end ContentModelArticles getListQuery() has two problems.

1. It doesn't work correctly if you a user is linked to more than one contact with different languages (see test instructions above).
2. It contains an unnecessary GROUP BY clause that dramatically slows down the processing when a site contains a large number of articles. See this thread for discussion about a site with 70k articles: https://groups.google.com/forum/#!topic/joomla-dev-general/sVFw9reqGGw%5B1-25-false%5D.

The proposed patch from Thomas Hunziker corrects both of these issues.
Opened On:
14 Jul 2013, 16:07 by Mark Dexter
Closed On:
17 Jul 2013, 2:50
Status:
Fixed in SVN/GitHub

Filed Under

  • Components
  • First
  • No Platform Implications
  • Second

Responses

Posted on 15 Jul 2013, 4:39 by Jean-Marie Simonet
@test
No undesired effect here on a Multilanguage site.
Looks like remains in the query a GROUP BY

GROUP BY cat.id ) AS badcats
Posted on 15 Jul 2013, 7:16 by Thomas Hunziker
This PR will only remove the GROUP BY on the main query. There is still one GROUP BY in a subquery which searchs the parent categories for unpublished or trashed categories. I think that one is still needed.
Posted on 15 Jul 2013, 9:44 by Jean-Marie Simonet
As Mark and I tested this ok, setting RTC
Posted on 17 Jul 2013, 2:50 by Jean-Marie Simonet
Fixed in 2.5.x. Thanks.
Posted on 16 Mar 2014, 4:21 by Sam O'neal

Thanks for useful information Mark!

http://nauseapnd.tumblr.com/