Slow saving and updating listings

Hi,

when saving a place from the backend I get this WordPress error:

Connection lost. Saving has been disabled until you’re reconnected. We’re backing up this post in your browser, just in case.

You have close to 600k listings, is that a dedicated server?

For such a big dataset MySql should be optimized and fine tuned by a PRO, or it risks to fail. I’ve asked to Stiofan to have a look and tell us if he can see anything else that could be causing this.

He’ll let you know asap.

Thanks

Sorry my reply failed to post last night, here it is:

Hello,

it seems to be a combination of many listings and many categories and many locations, when a listing is saved we rebuild the category term counts per location so this is a very very big loop in your case.

I have added a task to tackle this in different ways for big sites but for now this is the temp solution i can reccommend.

In your theme functions file near the top i have added the following lines

//disable term update on listing save
remove_action( 'geodir_after_save_listing', 'geodir_term_post_count_update', 100);

This will disable the term count update, if you add/remove many listings or change categories, i would suggest to comment out that line and then save a listing then uncomment it again to update your term counts. Y
Your place save times are now only a few seconds with this line added.

Thanks,

Stiofan

Thanks for letting us know 🙂

it seems to be a combination of many listings and many categories and many locations, when a listing is saved we rebuild the category term counts per location so this is a very very big loop in your case.

less than 0.1% of websites using our plugin should be in this case…

You are welcome,
keep us posted 🙂