Home › Forums › ACF PRO › Performance issues with hundreds of queries › Reply To: Performance issues with hundreds of queries
Ok that makes sense. I tried to use get_post_meta() at the beginning of my single.php but had some difficulties with deserializing my gallery-field… But isn‘t this field only queried once?
When I use the get_post_meta here would have to loop each attachment-ID with wp_get_attachment_image_src to get the sources for each image, which would go along with additional queries and would not improve the performance, right?
<?php $post_data = get_post_meta($post->ID);
$galerie_neu = $post_data['galerie_neu'][0];
if ($galerie_neu) {
($galerie_neu) {
$galerie_neu = unserialize($galerie_neu);
foreach ($galerie as $galerie_item) {
$galerie_id = $galerie_item['bild'];
$thumb = "galerie";
$full = "large";
$image = wp_get_attachment_image_src( $galerie_id, $thumb );
$fancybox = wp_get_attachment_image_src( $galerie_id, $full );
?>…
I guess the main amount of queries is generated through my option-fields (about 400 out of 600). I checked my database and found about 100 unused old fields which are not listed in the backend anymore – would deleting them enhance the performance?
Caching the option-fields would – in my optionion – solve my performance problem as every single page makes up to 100% use of all these fields. So I would have to manually change all option-field-entries in the DB to autoload = yes? Would that be a conclift issue with the JSON-feature?
I will mark your post as the solution – because it helps in generally but in my eyes does not help in my special case.
Thanks again for your help!
Welcome to the Advanced Custom Fields community forum.
Browse through ideas, snippets of code, questions and answers between fellow ACF users
Helping others is a great way to earn karma, gain badges and help ACF development!
We use cookies to offer you a better browsing experience, analyze site traffic and personalize content. Read about how we use cookies and how you can control them in our Privacy Policy. If you continue to use this site, you consent to our use of cookies.