Fitoussi / geo-my-wp

Advanced mapping and geolocation plugin for Wordpress
https://geomywp.com
36 stars 22 forks source link

Performance issue #74

Open AbhijithHaridas opened 3 years ago

AbhijithHaridas commented 3 years ago

Hey @Fitoussi, we have around 10000+ jobs on our site and the site back-end got really slow recently. It will take around 60+ seconds to load every back-end page. With the help of Query Monitor we have managed to track down the issue.

Yes, it was the WP Job Manager addon - Jobs Geolocation plugin that caused the slowdown. Based on the info on the Query Monitor it was taking around 58+ seconds to process all the query that is triggered by the gjm_import_locations() function in WP Job Manager addon - Jobs Geolocation plugin.

The worst part is that this is happening on every WP Back-end request.

Apart from the info presented by the Query Monitor we have tested this by Deactivating the plugin and the Back-end load time reduced significantly around 2 - 3 seconds

So kindly provide a patch for this as the plugin is very useful and we would like to use it

Let me know if you want any more technical info on this issue

Fitoussi commented 3 years ago

Hello @AbhijithHaridas,

Thanks for the info.

The gjm_import_locations() function should not execute on each page load. It should run only when triggering the "Import" button on the Setting page.

I know that Some users use this function dynamically with different Importer plugin. Have you checked that this is not case for you?

Regardless, I am going to look into this later today and see if this is something that need to be fixed.

Thanks, Eyal

AbhijithHaridas commented 3 years ago

Hey @Fitoussi, so surprised by your very quick reply, thank you

I myself is also a WP Developer and I would like to help you with this patch if there needs to be any

AbhijithHaridas commented 3 years ago

Strangely, we are using Version 2.3.2 I spotted this while comparing the code to the repo and it seems like the latest version is v3.7

But it is not showing the update option on the WP Plugins. Should I try updating the Plugin manually?

Fitoussi commented 3 years ago

You are welcome @AbhijithHaridas.

Not a problem, I am going on a few hours flight now. Will get home later today and will look into this.

Probably will get back to you by tomorrow with an update.

Fitoussi commented 3 years ago

@AbhijithHaridas,

This repository is for GEO my WP plugin which is a different plugin of mine.

WP Job Manager Geolocation is a premium plugin.

Please submit a ticket via this form -> https://jobmanagergeolocation.com/support/ and we will take it from there.