Bug issue when you had a lot of filters
-
Hi team,
I flood mySQL a lot of times ( with sometimes only 3 filters ). The meta queries produce too much INNER JOIN and the query has to be killed.
Did you tried your plugin with a lot of filters ?
May be a solution here : https://wordpress.stackexchange.com/questions/158898/meta-query-terribly-slow
Best regards,
Wilhem
-
Howdy Again Wilhelm,
We have tested with a large number of filters and databases. WP does at times get exponentially more expensive the more meta queries you have, which is due to the joins. There is certainly some room for improvement, you will see issues like this that have yet to be patched in core. When those are patched our plugin will run faster.
This leaves us with a few options:
- Stop doing things the “WordPress way”. But we are unlikely to do that.
- Use hooks in WPDB to speed up the queries where possible. We do this with The Events Calendar and it is a huge pain, it’s also the cause of a few plugin conflicts.
- Wait until core gets patched
Right now we are going with the third option. And until then anyone needing to run larger data sets needs a server powerful enough to handle the joins. Running InnoDB as your storage engine and tuning it to store more of database in memory can have a huge impact on the speed. This basically means that large databases will not do well on shared servers, but can still run very fast on a properly tuned server where you have control of what goes in memory. Just choose a VPS or better with the appropriate amount of power for your database, typically even a cheap one will be enough.
Cheers!
– Brook
- The topic ‘Bug issue when you had a lot of filters’ is closed to new replies.
