wordpress reloading time issue
-
Question: Optimizing Sitemap Performance for a Large WordPress Site on AWS EC2 with Bitnami
I am hosting a WordPress site on an AWS EC2 instance using a Bitnami stack. The database is hosted on Amazon RDS, and Redis is used as a caching layer along with the WP-Optimizer plugin. The site currently has a sitemap with around 20,000 pages, which is expected to grow to 100,000 pages.
The issue is that the sitemap and wp-admin pages are loading very slowly or eventually showing a 500 Internal Server Error. However, all other pages on the site are loading smoothly without issues. The server has enough memory and storage available, and the following configurations are in place:
Caching: Redis and WP-Optimizer are enabled.
Plugins: Rank Math Pro is used for generating the sitemap.
Logs: Apache error logs show warnings like:
Constant WP_MEMORY_LIMIT already defined
Undefined array keys “find” and “replace” in the Rank Math Pro plugin files.
Timeout errors (AH01075).
Server: EC2 instance with sufficient CPU, RAM, and disk space.
PHP-FPM: Default timeout settings.
Here’s what I’ve tried so far:
Optimized the wp-config.php file to remove duplicate constants like WP_MEMORY_LIMIT.
Updated all plugins, including Rank Math Pro, to the latest versions.
Increased PHP-FPM timeout in the configuration file.
Ensured the server resources are sufficient.
Despite these efforts, the sitemap still takes too long to load, and wp-admin occasionally shows internal server errors.
Questions:
How can I optimize the sitemap generation and loading process for such a large number of pages (20,000 to 100,000)?
Are there specific configurations or adjustments needed for Rank Math Pro to handle large sitemaps efficiently?
Is there any additional tuning required for Redis, Apache, or PHP-FPM to address these issues?
Would splitting the sitemap into smaller chunks or switching to a different sitemap generator plugin help resolve this problem?
Are there any known issues with large sitemaps on Bitnami stacks, and how can they be mitigated?
Any guidance on resolving these performance issues would be greatly appreciated. Thank you!The page I need help with: [log in to see the link]
- You must be logged in to reply to this topic.