Tagged: 7.0, database, performance, query, slow
In the backend of our website, editing a page for example or a WooCommerce product (using the classic editor, not the Advanced Layout builder) results in a lot of duplicate database queries which slows down the page load significantly on larger websites. Checked it on multiple websites.
Website 1: 84 of the same query is used
Website 2: 85 of the same query is used
The query:
SELECT post_id, meta_value
FROM wp_postmeta
WHERE meta_key = '_wp_attached_file'
AND meta_value = '/home/xxxxx/public_html/wp-content/themes/enfold/config-templatebuilder/avia-template-builder/assets/fonts/svg_entypo-fontello/svg/lock.svg'
I just reported another issue with exactly the same issue. Update to 7.0 made the site inaccessible due to the high database load.
Hi,
Thank you for the inquiry.
Please edit the framework/php/class-responsive-images.php and replace everything with this code:
— https://pastebin.com/vDJhhnzD
This will be included in the next patch.
Let us know the result.
Best regards,
Ismael