JoomlaWorks

Member Dashboard
  • Home
  • Extensions
    • Commercial
      • Frontpage Slideshow
      • K2 Plugin for sh404SEF
      • Simple Image Gallery Pro
      • SocialConnect
    • Free
      • K2
      • AllVideos
      • DISQUS Comments for Joomla!
      • IAKI (Import As K2 Image)
      • Simple Image Gallery
      • Simple RSS Feed Reader
    • Free On Github
      • Akismet for Kunena
      • Fill It Up
      • K2 Example Plugin
      • K2 Links for JCE
      • Rebuild K2 Image Cache (CLI utility for K2)
      • TinyLetter Subscribe
      • URL Normalizer
      • User Extended Fields for K2
  • Templates
    • Commercial Templates
      • Anagram
      • Archetype
      • BusinessOne
      • Ibento
      • Janaro
      • Kiji
      • Matchbox
      • nuMuzik
      • RadioWave
      • Toreda
    • Free Templates
      • nuModusVersus
      • Takai
  • Demos
    • Joomla Extension Demos
    • Joomla Template Demos
    • WordPress Plugin Demos
  • Labs
    • Web Apps
      • JoomlaReader
      • JSON 2 JSONP
      • Web Platform Tools
    • JavaScript Projects
      • Coming Soon...
  • Support
    • Documentation for Joomla Extensions
      • AllVideos
      • Frontpage Slideshow
      • Simple Image Gallery
      • Simple Image Gallery Pro
      • SocialConnect
    • Documentation for Joomla Templates
      • General Resources
        • Installation
        • Content
        • Customization
      • Commercial Templates
      • Free Templates
    • Get Help
      • Community Forum
        • Recent Topics
        • Categories
        • Create free account
      • Help Desk
      • Contact us by e-mail
      • Contact us on Facebook Messenger
      • Contact us on Twitter
  • About
    • Blog
    • Company
    • License & Terms of Service
    • Privacy Policy
  • My Account
04 12 2020
Written by  Fotis
Published in Blog
Tagged under
  • +Performance
  • +joomla articles
Be the first to comment!

Improve the performance of your Joomla articles (part 1)

Improve the performance of your Joomla articles (part 1)

The performance of the default article system in Joomla really sucks big time, that's a well know fact.

It''s actually one of the reasons we built K2 in the first place.

And as we venture into Joomla 4 territory, instead of seeing performance improvements (finally) for the entire database scheme, we actually witness new ways to mess up performance (if that was even possible). Apparently the Joomla core team likes to exercise who knows PHP's syntax better instead of actually building working code that doesn't break for extension developers every so.

Oh well, we're used to the mess.

Back to our topic.

Wanna improve the performance of the Joomla article system, especially in sites that filter/order content in various ways? Well, for starters add a few indices to the "content" table, e.g. using phpMyAdmin.

ALTER TABLE `#__content` ADD INDEX `idx_publishup` (`publish_up`);
ALTER TABLE `#__content` ADD INDEX `idx_publishdown` (`publish_down`);
ALTER TABLE `#__content` ADD INDEX `idx_modifiedby` (`modified_by`);
ALTER TABLE `#__content` ADD INDEX `idx_created` (`created`);
ALTER TABLE `#__content` ADD INDEX `idx_modified` (`modified`);

Just remember to replace #__ with your actual database prefix for Joomla.

But what's the measurable improvement? Well, something like this after you apply the above changes (on a really busy site that sorts articles by published date, aka 99% of Joomla sites)...

munin graph 20201204

Yeap.

And that's performance tip no.1. We'll come back with more in the future as we delve into the software architectural wonder that is Joomla 4.

Or do yourself a favour & switch to K2 which recently passed 4 million downloads, yeah! :)

To those who might say, hey why aren't you contributing that back to Joomla, well, our answer is that if you've ever contributed in Joomla, you know the painful process & bureaucracy and you juuuust might wish to keep your sanity.

Until next time.

Read 1806 times Last modified on Friday, 04 December 2020 19:27
Tweet

Leave a comment

Make sure you enter all the required information, indicated by an asterisk (*). HTML code is not allowed.

back to top
BY MAIL BY RSS

Archives

  • February 2021 (1)
  • December 2020 (1)
  • September 2020 (1)
  • June 2020 (1)
  • May 2020 (1)
  • February 2020 (1)
  • January 2020 (5)
  • December 2019 (2)
  • September 2019 (1)
  • July 2019 (3)
  • April 2019 (3)
  • February 2019 (4)

Tag Cloud

allvideos announcement apache community development frontpage slideshow joomla k2 Performance plugin release sh404sef simple image gallery simple image gallery pro simple rss feed reader socialconnect ssh tips update video

Latest Entries

  • Simple RSS Feed Reader v3.8.0 released
    Written by  Fotis
    03 Feb 2021
  • Improve the performance of your Joomla articles (part 1)
    Written by  Fotis
    04 Dec 2020
  • K2 Plugin for sh404SEF version 1.6.0 released
    Written by  Fotis
    14 Sep 2020
  • Simple Image Gallery Pro v3.8.0 released
    Written by  Fotis
    10 Jun 2020
  • AllVideos 6.1.0 now available - adds Mixcloud support
    Written by  Fotis
    22 May 2020

Join Our Newsletter

Enter your e-mail address to subscribe to our new or updated product notifications. We send combined newsletters, so we won't spam you every week :)

Get Social

  • Twitter
  • GitHub
  • Facebook
  • GitHub (K2)
  • YouTube
  • Speaker Deck

Grab Our Feeds

  • Extension Updates
  • Blog
  • Videos
  • Presentations
Copyright © 2006 - 2021 JoomlaWorks Ltd.
JoomlaWorks Ltd. and this site is not affiliated with or endorsed by The Joomla! Project™. Any products and services provided through this site are not supported or warrantied by The Joomla! Project or Open Source Matters, Inc. Use of the Joomla!® name, symbol, logo and related trademarks is permitted under a limited license granted by Open Source Matters, Inc.
designed by Nuevvo