I have submitted a couple of tickets on performance with my hosting service and here is their feedback:
#1 – This was from April 14th:
“I’m reaching out to let you know that the website is running into some issues regarding extremely large database queries which seem to be stemming from the GeoDirectory plugin. They’re impacting the site’s performance in regards to causing a spike in resource usage for the database.
The query in question is:
SELECT DISTINCT l.country_slug AS u, MAX(p.post_modified_gmt) AS date_gmt, l.country_slug AS country FROM wp_7j1sxwr223_geodir_post_locations l LEFT JOIN wp_7j1sxwr223_geodir_gd_place_detail pd ON pd.region = l.region LEFT JOIN wp_7j1sxwr223_posts p ON p.ID = pd.post_id WHERE p.post_type = ‘gd_place’ AND p.post_status = ‘publish’ AND l.location_id IS NOT NULL AND p.ID IS NOT NULL GROUP BY u ORDER BY date_gmt DESC
Just to kick things off, can you please ensure that the plugin is running on the latest version? We can check and see if the issue is still present once it’s been updated – if it does persist, we’ll need you to reach out to the plugin developer for some advice on optimising the database queries being executed by the plugin.”
#2 – This was from last night with regard to my question about GeoDirectory NOT EVEN BEING USED right now:
“In regards to the current state of the site, it looks like the massive resource spikes are coming from the geodir_buddypress plugin – a plugin combining the functions of both GeoDir and BuddyPress. The large database query referenced in my initial email is a constant thing, so it seems that even if GeoDir isn’t actively being used on the site, it’s still running behind the scenes.
If the WordPress admin dashboard is still timing out, it may require that the plugin be deactivated through SFTP (by renaming that specific plugin’s folder) – alternatively, we can deactivate it from our side of things in the meantime just so you can get back into the site! Let us know if you want us to deactivate the plugin, that should get the admin dashboard back up and running – the plugin can then be updated/activated again when needed, however, if it does start throwing through those huge queries, it may take the site down again.”
To open a new support ticket, first select the relevant forum and then click the "New Post" button. Example: You need support for the core plugin? Click on Core Plugin support and click on the "New Post" Button.