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)
      • Quick Menu (for Joomla 4)
      • 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
      • JSON 2 JSONP
      • Feed Reader (bookmarklet)
      • Device Info
  • 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  JoomlaWorks
Published in Blog
Tagged under
  • +Performance
  • +joomla articles
1 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 7718 times Last modified on Friday, 04 December 2020 19:27

1 comment

  • Gdo Gdo 21 Apr 2021
    Comment Link

    that was useful, waiting for part 2 :)

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

  • March 2023 (1)
  • January 2022 (1)
  • July 2021 (2)
  • May 2021 (1)
  • February 2021 (1)
  • December 2020 (1)
  • September 2020 (1)
  • June 2020 (1)
  • May 2020 (1)
  • February 2020 (1)
  • January 2020 (5)
  • December 2019 (2)

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

  • New free extension release: Quick Menu (for Joomla 4)
    Written by  JoomlaWorks
    06 Mar 2023
  • Simple Image Gallery (free) v4.2 released
    Written by  JoomlaWorks
    07 Jan 2022
  • Simple Image Gallery Pro v3.9.1 released (bug-fix release)
    Written by  JoomlaWorks
    26 Jul 2021
  • Simple Image Gallery Pro v3.9.0 released
    Written by  JoomlaWorks
    05 Jul 2021
  • Simple RSS Feed Reader v3.9.0 released
    Written by  JoomlaWorks
    25 May 2021

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 - 2023 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