Advertisement

Optimizing Joomla Site Performance with Large Databases

Discussion regarding Joomla! 5.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.
Windows Defender SmartScreen Issues <-- please read this if using Windows 10.
Post Reply
Danny958
Joomla! Fledgling
Joomla! Fledgling
Posts: 1
Joined: Thu Sep 19, 2024 1:51 am

Optimizing Joomla Site Performance with Large Databases

Post by Danny958 » Thu Sep 19, 2024 1:57 am

I'm running a Joomla website that pulls data from a large MySQL database, and I've noticed significant slowdowns during peak traffic. I've optimized caching and minimized plugins, but the load times remain high when querying the database. What strategies would you recommend for further optimization, particularly for handling large datasets efficiently in Joomla?

I found a general performance optimization guide here: [ redacted ] , but I’m seeking Joomla-specific solutions.
Last edited by toivo on Thu Sep 19, 2024 2:10 am, edited 1 time in total.
Reason: mod note: URL removed, please observe the warning about including links to non-Joomla websites!

Advertisement
User avatar
Per Yngve Berg
Joomla! Master
Joomla! Master
Posts: 31412
Joined: Mon Oct 27, 2008 9:27 pm
Location: Romerike, Norway

Re: Optimizing Joomla Site Performance with Large Databases

Post by Per Yngve Berg » Thu Sep 19, 2024 4:12 am

Have you changed Session Handler from 'database' to 'filesystem'?

You can also use Redis or Memcached to have Sessions in Memory.

User avatar
sakiss
Joomla! Explorer
Joomla! Explorer
Posts: 376
Joined: Wed Aug 20, 2008 4:09 pm

Re: Optimizing Joomla Site Performance with Large Databases

Post by sakiss » Thu Sep 19, 2024 11:38 am

1. Check the queries that create the load and find out if they are optimized (e.g. have the proper indexes).
2. You can identify from where these queries comes and check if the extension executing them has any support for an in-memory caching system like MemCached or Redis. These can alleviate your db.
Joomla has some support for both, but mainly for the Session handling.
If these queries come from a 3rd party extension, you can ask the developer of that extension for integration.

rehansaeed
Joomla! Fledgling
Joomla! Fledgling
Posts: 1
Joined: Wed Sep 18, 2024 7:49 am

Re: Optimizing Joomla Site Performance with Large Databases

Post by rehansaeed » Thu Sep 19, 2024 1:01 pm

To optimize Joomla performance with large databases, enable caching, optimize database queries, use a content delivery network (CDN), compress images, minimize extensions, and implement database indexing for faster load times.

User avatar
Slackervaara
Joomla! Ace
Joomla! Ace
Posts: 1127
Joined: Sat Aug 13, 2011 6:27 am

Re: Optimizing Joomla Site Performance with Large Databases

Post by Slackervaara » Wed Sep 25, 2024 6:43 pm

For my site the best perfomance boost was to block bad bots. They took most traffic and load of the site. But I have 10 000 articles and 500 000 forumposts.

Advertisement

Post Reply

Return to “Performance - Joomla! 5.x”