‘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.
