‘LIKE’ are slow. Any query that searches the meta_value column is slow because it is not indexed. ‘LIKE’ queries on the meta_value field are even slower. This may or may not have a large impact on site performance, it really depends on how many of these queries you are doing.
Welcome to the Advanced Custom Fields community forum.
Browse through ideas, snippets of code, questions and answers between fellow ACF users