One character searches using a custom filter with index table.

Good morning.

I’m using a custom filtering system with your product and have the search set to an index table. I’m on a very fast server at WP Engine and have a quick question.

The search itself is very fast. I noticed last night though, when searching for a single letter or number or a string of characters such as “a b c d e f g”

There seems to be a 6-7 second delay. I’m assuming it’s searching through the entire index table?

It doesn’t seem to be doing this for two character searches.

This is my custom functions.php script. Is there any way I can eliminate one character searches or searches like I had above “a b c d e…”

/**
* Ajax Search Pro – Filter search results by language parameter.
* This function uses the plugin’s native ‘post_meta_filter’ argument to filter by a custom field.
*
* @link https://knowledgebase.ajaxsearchpro.com/hooks/filters/query-and-output/asp_query_args
*/

add_filter( ‘asp_query_args’, function( $args ) {

// Get the ‘lang’ parameter from the URL, e.g., ?lang=en
$lang = isset( $_GET[‘lang’] ) ? sanitize_key( $_GET[‘lang’] ) : ”;

// Proceed only if the lang parameter is one of the languages we want to filter by.
if ( in_array( $lang, [ ‘en’, ‘es’ ] ) ) {

// — THE FIX IS HERE —
// Manually wrap the string value in single quotes for the raw SQL query.
// This is necessary because ASP appears to inject the value directly into the query.
$language_value = ( $lang == ‘en’ ) ? ‘”English”‘ : ‘”Spanish”‘;

// 1. Define the rule using the structure required by Ajax Search Pro.
$language_rule = array(
‘key’ => ‘href_lang_language’, // The meta key to check.
‘value’ => $language_value, // The meta value to match (now with quotes)
‘operator’ => ‘=’, // The comparison operator.
);

// 2. Add the rule to the ‘post_meta_filter’ array.
if ( ! isset($args[‘post_meta_filter’]) || ! is_array($args[‘post_meta_filter’]) ) {
$args[‘post_meta_filter’] = [];
}
$args[‘post_meta_filter’][] = $language_rule;

}

return $args;
}, 99, 1 );

// keep lang in query vars
add_filter( ‘query_vars’, function( $vars ){
$vars[] = ‘lang’;
return $vars;
} );