I notice that you are using 3 page builders on the site (the Cornerstone builder that comes with your theme, Layouts which comes with Toolset, and WP Bakery). You should choose one and deactivate the other two.
I tried searching on the page a couple of times. The first time the results were returned after 4s, which is not great nor is it too bad, but the second time it took about 20 seconds, which suggests an underlying problem.
In such situations I recommend installing the Query Monitor plugin, which will detail all of the database requests that happen through the lifecycle of constructing a page, and which should help narrow down if there are certain queries running particularly slowly, or if there are an unexpectedly high number of queries.
Try that, but if you are not able to interpret the results, let me know and I can take a look to see if anything obvious jumps out.
I tried to test the views with different page builder and the results weren't quicker. I took your second advice and installed Query Monitor but It doesn't help me much. I would appreciate some help to interpret the results.
I can take a look if you want to give me access to your site.
I will mark your next reply as private so that I can get log-in credentials from you—you may want to create a temporary admin user for me to use that you can later delete. And be sure to have a current backup of your site, even though I don't intend to make any changes.
I looked at the results of Query Monitor and identified a number of slow queries which originate from Views that would help explain the slow page loading on the search results page.
I've passed this on to my second tier colleagues who can spend longer debugging it to see if there are any areas where this can be improved, and I'll let you know when they report back.
Note, while checking your site I noticed a few JS errors in the console (not related to the slow queries) which you should investigate. Try disabling plugins and switching theme to see if you can identify the source.
Also, there were some PHP notices, in particular it appears that you defined WP_MEMORY_LIMIT and WP_MAX_MEMORY_LIMIT more than once in wp-config.php.
This project has been put on side for a while but now we need help again. I've saw when i disable the plugin Toolset Map, the performances are very good. Is there something wrong with the cache option? Or did I made mistakes in my queries?
The feedback is not too helpful for you, inasmuch as the slowness is expected when using location-based searches with Maps on anything other than fairly modest sites.
The way the data is stored and queries constructed is not optimised for larger sites.
This is a known problem and we have an internal ticket about creating dedicated database tables for location data to speed things up considerably, but it is not being worked on right now.
Hi,
Thanks for the answer but it's really an inconfortable situation for us. We write to the product manager and hope he'll find a solution because we can't use the website in this situation.
I've shared more details of the issue with the product manager who I understand has written directly to you to confirm that we will move forward the work required to better scale maps distance searches.
I'm pleased to say that the developer has completed the work and reports impressive improvements in performance. The Maps plugin is scheduled for testing before it can be released. I don't have a specific timescale for when the update will be published, but it will be soon.
