Fix WordPress Property Site Speed
Budget: $10 – $30 USD
My WordPress real-estate portal :
www.qrar.net
hosts around 160 k listings and the database has swollen to 8 million rows—well over 7 million of them live in wp_postmeta. Even on a VPS with 6 vCPUs, 64 GB RAM, NVMe drives and Plesk, the homepage now times out completely, while the admin area, search results and individual property pages work but slow.
Here is what I have already tried:
• Converted every table from InnoDB to MyISAM and ran full table repairs.
• Performed what I believe is full indexing and optimization of the database.
• Installed and configured WP Rocket to serve thats supposed to improve speed and caches, static versions of every page.
None of these steps solved the problem. According to my own observation the slowdown is currently isolated to the homepage, but other pages are still noticeably sluggish. I have not yet disabled the theme or plugins for comparison tests—the site is running the “MyHome” ThemeForest theme (https://themeforest.net/item/myhome-real-estate-wordpress-theme/19508653).
I need an expert who can:
1. Identify the true performance bottleneck—database queries, theme code, server configuration, or something else.
2. Implement targeted fixes so the homepage loads consistently in a few seconds and the rest of the site responds briskly.
3. Provide clear notes on what was changed so I can maintain the solution going forward.
Acceptance criteria
• Homepage renders fully without time-outs under normal traffic.
• Search results and property pages load in under 3 s on first view and under 1 s when cached.
• No loss of data or front-end functionality.
If you have deep experience with large-scale WordPress installs, heavy wp_postmeta tables, query optimization, object caching, Redis/Memcached, or theme refactoring, you should find this an interesting challenge. Please tell me how you would approach the diagnosis and outline any tools (Query Monitor, New Relic, WP-CLI, etc.) you plan to use.
www.qrar.net
hosts around 160 k listings and the database has swollen to 8 million rows—well over 7 million of them live in wp_postmeta. Even on a VPS with 6 vCPUs, 64 GB RAM, NVMe drives and Plesk, the homepage now times out completely, while the admin area, search results and individual property pages work but slow.
Here is what I have already tried:
• Converted every table from InnoDB to MyISAM and ran full table repairs.
• Performed what I believe is full indexing and optimization of the database.
• Installed and configured WP Rocket to serve thats supposed to improve speed and caches, static versions of every page.
None of these steps solved the problem. According to my own observation the slowdown is currently isolated to the homepage, but other pages are still noticeably sluggish. I have not yet disabled the theme or plugins for comparison tests—the site is running the “MyHome” ThemeForest theme (https://themeforest.net/item/myhome-real-estate-wordpress-theme/19508653).
I need an expert who can:
1. Identify the true performance bottleneck—database queries, theme code, server configuration, or something else.
2. Implement targeted fixes so the homepage loads consistently in a few seconds and the rest of the site responds briskly.
3. Provide clear notes on what was changed so I can maintain the solution going forward.
Acceptance criteria
• Homepage renders fully without time-outs under normal traffic.
• Search results and property pages load in under 3 s on first view and under 1 s when cached.
• No loss of data or front-end functionality.
If you have deep experience with large-scale WordPress installs, heavy wp_postmeta tables, query optimization, object caching, Redis/Memcached, or theme refactoring, you should find this an interesting challenge. Please tell me how you would approach the diagnosis and outline any tools (Query Monitor, New Relic, WP-CLI, etc.) you plan to use.