WP_Site_Health::should_suggest_persistent_object_cache(): bool

3584	public function should_suggest_persistent_object_cache() {3585		global $wpdb;3586 3587		/**3588		 * Filters whether to suggest use of a persistent object cache and bypass default threshold checks.3589		 *3590		 * Using this filter allows to override the default logic, effectively short-circuiting the method.3591		 *3592		 * @since 6.1.03593		 *3594		 * @param bool|null $suggest Boolean to short-circuit, for whether to suggest using a persistent object cache.3595		 *                           Default null.3596		 */3597		$short_circuit = apply_filters( 'site_status_should_suggest_persistent_object_cache', null );3598		if ( is_bool( $short_circuit ) ) {3599			return $short_circuit;3600		}3601 3602		if ( is_multisite() ) {3603			return true;3604		}3605 3606		/**3607		 * Filters the thresholds used to determine whether to suggest the use of a persistent object cache.3608		 *3609		 * @since 6.1.03610		 *3611		 * @param int[] $thresholds The list of threshold numbers keyed by threshold name.3612		 */3613		$thresholds = apply_filters(3614			'site_status_persistent_object_cache_thresholds',3615			array(3616				'alloptions_count' => 500,3617				'alloptions_bytes' => 100000,3618				'comments_count'   => 1000,3619				'options_count'    => 1000,3620				'posts_count'      => 1000,3621				'terms_count'      => 1000,3622				'users_count'      => 1000,3623			)3624		);3625 3626		$alloptions = wp_load_alloptions();3627 3628		if ( $thresholds['alloptions_count'] < count( $alloptions ) ) {3629			return true;3630		}3631 3632		if ( $thresholds['alloptions_bytes'] < strlen( serialize( $alloptions ) ) ) {3633			return true;3634		}3635 3636		$table_names = implode( "','", array( $wpdb->comments, $wpdb->options, $wpdb->posts, $wpdb->terms, $wpdb->users ) );3637 3638		// With InnoDB the `TABLE_ROWS` are estimates, which are accurate enough and faster to retrieve than individual `COUNT()` queries.3639		$results = $wpdb->get_results(3640			$wpdb->prepare(3641				// phpcs:ignore WordPress.DB.PreparedSQL.InterpolatedNotPrepared -- This query cannot use interpolation.3642				"SELECT TABLE_NAME AS 'table', TABLE_ROWS AS 'rows', SUM(data_length + index_length) as 'bytes' FROM information_schema.TABLES WHERE TABLE_SCHEMA = %s AND TABLE_NAME IN ('$table_names') GROUP BY TABLE_NAME;",3643				DB_NAME3644			),3645			OBJECT_K3646		);3647 3648		$threshold_map = array(3649			'comments_count' => $wpdb->comments,3650			'options_count'  => $wpdb->options,3651			'posts_count'    => $wpdb->posts,3652			'terms_count'    => $wpdb->terms,3653			'users_count'    => $wpdb->users,3654		);3655 3656		foreach ( $threshold_map as $threshold => $table ) {3657			if ( $thresholds[ $threshold ] <= $results[ $table ]->rows ) {3658				return true;3659			}3660		}3661 3662		return false;3663	}
When	Instructions	Calls it makes
`is_bool($short_circuit)`	9	`apply_filters()`
`!is_bool($short_circuit) && is_multisite()`	12	`apply_filters(), is_multisite()`
`!is_bool($short_circuit) && !is_multisite()`	24	`apply_filters(), is_multisite(), apply_filters(), wp_load_alloptions()`
`!is_bool($short_circuit) && !is_multisite()`	31	`apply_filters(), is_multisite(), apply_filters(), wp_load_alloptions(), serialize()`
`!is_bool($short_circuit) && !is_multisite()`	69–76	`apply_filters(), is_multisite(), apply_filters(), wp_load_alloptions(), serialize(), ->prepare(), ->get_results()`
PHP	Compiled	Executed	Branches	Notes
8.6-dev	82	9–76	7
8.5	82	9–76	7
8.4	82	9–76	7	4 fewer instructions than PHP 8.3
8.3	86	9–80	7
8.2	86	9–80	7
8.1	86	9–80	7
7.4	86	9–80	7