Recently Added Articles in backend

Discussion regarding Joomla! 3.x Performance issues.

Moderator: General Support Moderators

Forum rules
Forum Rules
Absolute Beginner's Guide to Joomla! <-- please read before posting, this means YOU.
Forum Post Assistant - If you are serious about wanting help, you will use this tool to help you post.
Locked
zorro128
Joomla! Enthusiast
Joomla! Enthusiast
Posts: 153
Joined: Tue Sep 27, 2005 7:27 am
Contact:

Recently Added Articles in backend

Post by zorro128 » Sun Jan 20, 2013 3:04 pm

I have noticed in Recently Added Articles module in administration that is listing all recoreds from content table. If you have large number of articles load time is huge.

In debug mode following query is used for listing articles:

Code: Select all

SELECT a.id, a.title, a.checked_out, a.checked_out_time, a.access, a.created, a.created_by, a.created_by_alias, a.featured, a.state,l.title AS language_title,uc.name AS editor,ag.title AS access_level,c.title AS category_title,ua.name AS author_name
  FROM jos_content AS a
  LEFT JOIN `jos_languages` AS l
  ON l.lang_code = a.language
  LEFT JOIN jos_users AS uc
  ON uc.id=a.checked_out
  LEFT JOIN jos_viewlevels AS ag
  ON ag.id = a.access
  LEFT JOIN jos_categories AS c
  ON c.id = a.catid
  LEFT JOIN jos_users AS ua
  ON ua.id = a.created_by
  ORDER BY created DESC
In my case it returns over 20 000 records.

Locked

Return to “Performance - Joomla! 3.x”