Weak Performance with 10.000+ Posts

Hi @nicmare,

Thank you for your message.

Unfortunately, due to the structure of the database (most of the data is only in two tables – wp_posts and wp_postmeta), query performance may be limited. Data from the ACF plugin is also stored in these tables. In this situation, I recommend that you activate Lite mode in the plugin settings. This should significantly speed up search performance.

Best,
Mateusz

i found the filter to alter your query to provide static custom field name in the query where “name_de” is one of my custom fields:

function improve_acfbs($join){
	
	$strings = explode("AND",$join);
	foreach($strings as $key=>$string){
				
	if(str_contains($string,"acfbs_allow_search"))
		unset($strings[$key]);
	}
	$strings[] = " ( c.post_title = 'name_de')) ";
	$new_join = implode("AND",$strings);
	
	return $new_join;
}
add_filter("acfbs_sql_join", 'improve_acfbs');

seems a little bit faster but still very slow. But i am sharing this code if someone needs it as well for some reason.

• This reply was modified 1 year, 9 months ago by nicmare.

OR simply with the post_id of your custom field:

function improve_acfbs($join){
	if(!str_contains($join,"acfbs_allow_search")) return $join;

	$strings = explode("AND",$join);
	foreach($strings as $key=>$string){
		
	if(str_contains($string,"acfbs_allow_search"))
			unset($strings[$key]);
		if(str_contains($string,"acf-field"))
			unset($strings[$key]);
	}
	$strings[] = sprintf(" ( c.ID = %s ) ",1925 ); // post_id of your custom field

	$new_join = sprintf("%s )",implode("AND",$strings));
	
	return $new_join;
}
add_filter("acfbs_sql_join",'improve_acfbs');