- This topic has 54 replies, 3 voices, and was last updated 8 years, 5 months ago by
.
-
Posts
-
Hello Uwe,
Thanks for hanging in there.
I had couple discussions on this topic as someone else also flagged a similar issue.
The long query looks like it is coming from a page with filter bar and lots of filters active.
Why this can perform poorly is partly related to how many posts you have in the wp_posts table, and what sort of hosting resources are available to you.
If so many filters are being used (many choices are clicked) then a complex query like you posted needs to run, there is no way out of that. Developing a fix for that (it’s not really broken though, right?) would require changing our whole plugin ecosystem and major refactoring. (Still, the long query would need to run.)
At the moment all I can give you is a couple of suggestions to remedy the issue:
- reduce the number of filters
- reduce the number of options in the filters
- change the filters from autocomplete and checkbox to dropdown to allow only one selection in a filter, not multiple
- limit the number of options the user can choose from a dropdown (needs custom coding)
- and of course getting more server resources
I understand that these suggestions might be somewhat limiting the functionality of the website or have cost implications, but unfortunately this is all I can do at the moment, I’m really sorry.
I do hope this helps somewhat and of course if you have further questions, don’t hesitate to reach out.
Cheers,
AndrasHello Uwe,
I can understand the issue is frustrating and it is difficult to move forward.
I will check with someone from the development team what they make of the above.
As for php7, our plugin is tested and supports it. Both my local and my live test sites are running on some version of php 7.x.
I’ll be in touch soon.
Cheers,
Andras
- The topic ‘Urgent – Production issue – Long running query’ is closed to new replies.