More than 23 000 products on this demo site – answer to the question about performance. Shared hosting, PHP 8.0.12, MySQL 5.7.33!
Products imported, edited. Then cloned to 23K by WOOBE
Product Color Product Color Filter products by color using relevant filter!