This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
add_filter('gpeb_filters_col_rows_query', 'custom_optimize_gf_entry_meta_query_with_cache', 10, 3); | |
function custom_optimize_gf_entry_meta_query_with_cache($sql, $col, $table) { | |
// Check if the current table and column are the ones we want to optimize | |
if ($table === GFFormsModel::get_entry_meta_table_name() && $col === 'meta_key') { | |
// Attempt to retrieve cached meta_key results | |
$cached_meta_keys = get_transient('gf_entry_meta_keys'); | |
// If the cache exists, skip running the query | |
if ($cached_meta_keys !== false) { |