Forum Replies Created
-
AuthorPosts
-
October 23, 2024 at 8:16 am in reply to: Clicking anchor links, element disappears under sticky header on mobile #1469666
Yes, we did modify it through CSS. Is it possible to change the behavior of the scroll somehow on mobile? We want to use the sticky header on mobile on several websites. Perhaps you can check in your code (javascript) if the header has a position:fixed and change the offset for the scroll.
Thanks!
Removing the ORDER BY and adding a LIMIT does the trick indeed:
Without ‘LIMIT’ the query is still slow.
- This reply was modified 4 months, 2 weeks ago by roelvanleuken.
It’s not doing anything unfortunately:
The database index is not being used when a wildcard is used in the query. As far as I know, that is normal MySQL behavior. I’m not sure why the index is used in your own hosting environment..
- This reply was modified 4 months, 2 weeks ago by roelvanleuken.
Temporary fix for anyone experiencing the same issue (until the authors of Enfold fix this issue permanently):
Add this to your child theme’s functions.php:
// Enfold 6.0 slow query fix add_filter('avf_before_query_wp_default_custom_fields', function($custom_fields) { return []; });
The dynamic custom fields don’t work anymore with this line, but at least your website is working again.
July 10, 2024 at 8:44 am in reply to: Updating to version 6.0 has made one of our websites unusable #1461756We had to revert back to Enfold 5.7. Or you can add this to your child theme’s functions.php as a temporary fix until the authors of Enfold fix this issue:
// Enfold 6.0 slow query fix add_filter('avf_before_query_wp_default_custom_fields', function($custom_fields) { return []; });
The dynamic custom fields don’t work anymore with this line, but at least your website is working again.
July 10, 2024 at 8:27 am in reply to: theme is querying all meta keys from the postmeta table every time this function #1461755The function is called in the frontend as well in 6.0.
See this related topic here:
We will this investigate at our end (why indexes are not used properly), we’re running several servers where this issue all occur.
You have to keep in mind that not all hostingservers are equally configured. We are probably not the only one running into this.
I understand the need of retrieving all custom fields, but I’m sure there are better ways (performance wise) to achieve this (using WP transients, retrieving them with a WP Cron and so on..).
Thanks for your quick response. Our table contains 11 million records (1GB in size).
The ‘NOT LIKE’ part skips the index, see the attached screenshot:
You should optimize this somehow (using WP transients? using a more optimized database query?).
Disabling it on the frontend still gives us issues on the backend off course.
July 23, 2021 at 9:34 am in reply to: Enfold Widgets For Footer Not Working With WordPress 5.8 #1311767Same here, the ‘newsbox’ throws an error in the new widget area since WP 5.8 update.
-
AuthorPosts