Loading Page very very slow

Hi,

In 99% of the cases, performances issues with the variants is because they are used for something you don't need them for, and thus, improving the speed is not a matter of improving the sql / server processing, etc but configuring the products differently.

The first thing I would recommend it to check if you can remove one or several characteristics from the products.
There are two ways to do that:
- you split the product into several products. So for example, for the product you provided, you could have 3 products, one for each color of the frame and that would reduce the number of variants for each product to 80, which is much more manageable.
- having variants for a product is usually used because you want to have a different stock for each variant, or a different price for each variant, or a different image for each variant, etc so that the information displayed on the product page switches when the new variant is selected. I checked your page but it seems that for most of your characteristics, regardless of what I select in the dropdown, nothing changes. In that case, rather than having a characteristic, you could instead have a custom field of the table "item" (you can create that via the menu Display>Custom fields). So for example, if you remove the frame color characteristic and use instead a custom item field, that will also reduce the number of variants to 80, drastically improving the performances.