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