Automattic\WooCommerce\Internal\Products

ProductsOrderingReindexService::reindex_products │ public │ WC 11.2.0

Designed for an HVM with 500K+ products catalog operating in a clustered environment. To satisfy this setup:

• The batch size is set to 250. Increasing this value may negatively impact catalog browsing performance.
• Cache invalidation targets the posts cache only, since menu_order lives in wp_posts and is not stored in meta or term caches.
• Resources allocation for 500K products catalog: product-position map - 20 MB RAM, 2000 SQLs for full reindexing ± 2 seconds.

Метод класса: ProductsOrderingReindexService{}

Хуков нет.

Возвращает

array<int,int>.

Использование

$ProductsOrderingReindexService = new ProductsOrderingReindexService();
$ProductsOrderingReindexService->reindex_products( $batch_size ): array;

$batch_size(int)

Number of products included in each batch for re-indexing.
По умолчанию: 250

Список изменений

Код ProductsOrderingReindexService::reindex_products() ProductsOrderingReindexService::reindex products ^{WC 11.2.2}

public function reindex_products( int $batch_size = 250 ): array {
	global $wpdb;

	// Performance note: prefetch product ids; enables deterministic behaviour and faster queries below.
	// phpcs:ignore WordPress.DB.DirectDatabaseQuery.DirectQuery, WordPress.DB.DirectDatabaseQuery.NoCaching
	$product_ids = array_map( 'intval', $wpdb->get_col( "SELECT ID FROM {$wpdb->posts} WHERE post_type = 'product' ORDER BY menu_order ASC, post_title ASC, ID ASC" ) );

	$result           = array();
	$current_position = 1;
	for ( $offset = 0, $total = count( $product_ids ), $batch_size = max( 1, $batch_size ); $offset < $total; $offset += $batch_size ) {
		$batch_ids       = array_slice( $product_ids, $offset, $batch_size );
		$batch_positions = array();
		$batch_branches  = array();
		foreach ( $batch_ids as $id ) {
			$batch_positions[ $id ] = $current_position;
			$batch_branches[]       = sprintf( 'WHEN %d THEN %d', $id, $current_position++ );
		}

		$batch_branches = implode( ' ', $batch_branches );
		$in_values      = implode( ', ', $batch_ids );
		// phpcs:ignore WordPress.DB.DirectDatabaseQuery.DirectQuery, WordPress.DB.DirectDatabaseQuery.NoCaching, WordPress.DB.PreparedSQL.NotPrepared, WordPress.DB.PreparedSQL.InterpolatedNotPrepared
		$updated = (int) $wpdb->query( "UPDATE {$wpdb->posts} SET menu_order = CASE ID {$batch_branches} END WHERE ID IN ( {$in_values} )" );
		if ( $updated > 0 ) {
			// Performance note: fires `clean_post_cache` action per product for extensions compatibility (WooCommerce v11.2).
			// Targeted wp_cache_delete_multiple + wp_cache_set_posts_last_changed is fast, but insufficient for extensibility surface.
			array_walk( $batch_ids, 'clean_post_cache' );

			// Update the result entries only if update is confirmed.
			foreach ( $batch_positions as $id => $position ) {
				$result[ $id ] = $position;
			}
		}
	}

	return $result;
}