I have a database of 8,000 truck stops in the USA. The problem is then someone clicks on a state (Florida), it takes 15-20 seconds for the page to display. I have traced it to listinghive pulling the meta for all the addresses, even if not displaying all the pins. (I have been deep diving this for multiple days.)
If I delete the geolocation plugin, it deletes the addresses for all 8,000 as they are tied to the plugin. Is there a way - without custom code - to move the addresses for each location from the plugin into just a listinghive attribute so I can continue to serve it to my visitors???
Please note that WordPress always loads meta fields for posts by default [listings are a custom post type], this is core WordPress behavior. The query itself is what’s causing the freeze, which can happen due to several factors: the number of listings, active search filters, other optimization issues, or server performance. Additionally, using regions for geolocation can significantly improve search performance, as region-based searches are faster than radius-based searches.
If possible, please send temporary WP access to support@hivepress.io with the link to this topic, and we’ll check it (please send only the link, without login and password). You can create a temporary access link using this plugin. Maybe we would be able to give some recommendations on optimization.
As a workaround, if you use search by states, and a precise address, radius search, and other features from geolocation are not needed, you can try using a custom attribute of a select type with the list of states.