I do something along the lines of what @jarvis suggests, but forgot about it. I have done something like this is the past. In my case I collect a lot of information from posts and store the collected information in the wp_options table. Basically I have a options value that is an array
array( $post_id => array( // nested array contains data for post ) )
This is updated whenever a post is saved. So that instead of doing a query to get the posts I just get the option value.
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!
© 2023 Advanced Custom Fields.