HUSKY Filters: 100,000-product benchmark

Dave Hilditch •

HUSKY filters was tested on 100,000 simple products with Redis object caching off and on. The benchmark used ten fixed filter cases, requested twice, with expected product counts checked on every request.

In this run, Redis changed the second-pass average from 1300.300 ms to 412.290 ms, a 888.010 ms reduction. This is one controlled run per cache mode, not a claim that Redis always changes network TTFB by the same amount.

Filter request results

RedisCorrectFirst-pass TTFBSecond-pass TTFBPHP renderDB queriesPeak PHP memory
Off20/201322.410 ms1300.300 ms1258.175 ms266.0522.10 MiB
On20/20886.180 ms412.290 ms592.772 ms24.9024.55 MiB

TTFB includes network and web-server time. PHP render time, database queries and peak request memory are reported separately so a network fluctuation is not mistaken for plugin execution time.

Visitor and wp-admin response

Independent page probes ran before, during and after the fixed filter workload. Values are average TTFB.

RedisVisitor before / during / afterwp-admin before / during / after
Off1742.940 / 1774.811 / 1691.060 ms164.440 / 260.522 / 166.080 ms
On921.360 / 818.300 / 796.220 ms158.700 / 195.175 / 160.360 ms

Measured server activity

RedisCPU avg / maxRAM avg / maxCPU core-seconds
Off37.85% / 54.64%4487.2 / 4537.3 MiB47.131
On28.55% / 50.38%4565.7 / 4617.7 MiB23.171

Method, versions and reproducibility

The catalogue contained 100,000 simple products. Each configuration ran the same ten semantic cases twice in a fixed order, starting with the shop page. The cases covered the shop, category, brand, colour, size and combined filters. Every recorded request returned the expected product count.

ComponentValue
Server4 AMD EPYC-Genoa vCPUs, 8.12 GB RAM and SSD storage
StackWordPress 7.0.4, WooCommerce 10.3.8, PHP 8.2.33 and MariaDB 10.11.17
Tested softwareHUSKY – Products Filter for WooCommerce Professional 1.4.3.1
Catalogue100,000 simple products
Catalogue SHA-2560224bc639f297125f1ad5216b2d29e1c0b55403ee1aac49f027701ecbafa26ed
Correctness20 of 20 requests correct in every configuration

Download the complete reproduction ZIP. It contains the exact catalogue CSV, the ten-case corpus, scenarios, effective configurations, environment and software inventories, a reproduction guide and SHA-256 checksums. Plugin packages are not included.

Inspect the complete compact result JSON, chart data or readable data report.

Absolute timings vary with hardware, database state, cache state and hosting limits. The exact inputs and configurations are public so this result can be challenged and repeated.

Comments

▲
▼
1/1