Optimizing Joomla Site Performance with Large Databases

[Danny958]

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.

[Per Yngve Berg]

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

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

[sakiss]

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]

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.

[Slackervaara]

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.