Commit feb3cefb77c for woocommerce

commit feb3cefb77cfebc0b2cb32768d410c9c2ad80b2d
Author: Vladimir Reznichenko <kalessil@gmail.com>
Date:   Thu Jul 2 14:21:10 2026 +0200

    [Performance] Disable counters in category filter on admin products page (#66176)

    Disables counters in the category filter on the admin products page to address performance issues with large product catalogs.

diff --git a/plugins/woocommerce/changelog/performance-slow-sql-on-admin-products-page b/plugins/woocommerce/changelog/performance-slow-sql-on-admin-products-page
new file mode 100644
index 00000000000..29be6565c1f
--- /dev/null
+++ b/plugins/woocommerce/changelog/performance-slow-sql-on-admin-products-page
@@ -0,0 +1,4 @@
+Significance: minor
+Type: performance
+
+Disabled counters in the category filter on the admin products page to address performance issues with large product catalogs.
diff --git a/plugins/woocommerce/includes/admin/list-tables/class-wc-admin-list-table-products.php b/plugins/woocommerce/includes/admin/list-tables/class-wc-admin-list-table-products.php
index a54924fc5d2..1cce6802fad 100644
--- a/plugins/woocommerce/includes/admin/list-tables/class-wc-admin-list-table-products.php
+++ b/plugins/woocommerce/includes/admin/list-tables/class-wc-admin-list-table-products.php
@@ -435,6 +435,10 @@ class WC_Admin_List_Table_Products extends WC_Admin_List_Table {
 				array(
 					'option_select_text' => __( 'Filter by category', 'woocommerce' ),
 					'hide_empty'         => 0,
+					// Performance note: pad_counts=0 skips the hierarchical count SQL — O(all published products), degrades linearly
+					// with catalog size. show_count=0 suppresses the raw wp_term_taxonomy.count that would otherwise render in its place.
+					'pad_counts'         => 0,
+					'show_count'         => 0,
 				)
 			);
 		} else {