Why not add ordering by Article IDs

For better query performance, can you explore including ordering or pulling the articles to be displayed by article IDs Descending to the list of available options. Please see the attached image. When you Order by Recently Published First, the query has to look at all the dates before sorting them by most recent which is takes more time depending on the number of articles you're looking at. Sorting by Article IDs in descending order in my experience is way faster. Please explore this as it will make this module faster. 

Thank you
3 months 2 weeks ago #1 by Adanku
Attachments:

Please Log in or Create an account to join the conversation.

  • Posted by TemplatePlazza (5195) Offline
Hi, Minifrontpage follows the standard Joomla latest news module query. I am not sure why the Joomla core devs are not using article IDs but considering that Joomla has a caching feature to cache all modules, I don't think ordering by article IDs would significantly improve load times compared to other options. However, I will still consider adding it. Thanks for the suggestion
3 months 2 weeks ago - 3 months 2 weeks ago #2 by TemplatePlazza
Last edit: 3 months 2 weeks ago by TemplatePlazza.

Please Log in or Create an account to join the conversation.

Powered by Kunena Forum