[tkstarley]

Sorry, right you are. Atelier 1.73 w/ WC 2.4 == 1501 queries

I have the feeling there is something not right here. I’ll investigate further.

[tkstarley]

And just to confirm, same data, theme 2015, WC 2.4 = 88 queries.

Get the theme updated to WC 2.4 🙂

[tkstarley]

Hey Ed,

Good question. To confirm, we’re using the WooCom 2.3 templates.

110 products (some content has slightly changed since first post), some with around 200 variants.

Atelier – 1,537 queries
Atelier with my mod – 888 queries
2015 – 796 queries

So right you are, I’ve got very high queries generally… and this seems to be the variants.

WC have overhauled the way variants work in 2.4, so I hope when the theme gets updated to 2.4, that will help us with the many variants issue. Happy to test again when that happens.

https://woocommerce.wordpress.com/2015/07/13/improving-the-variations-interface-in-2-4/

Thanks,
Kevin

[tkstarley]

That’s cool to remove loading of product variations, good to hear and thanks. But that is only part of the story, we’d still be getting around 800 queries on the product listing, even without that. The whole template needs a good review.

Ok, thanks for you time. Good luck!

[tkstarley]

You can also enable gzip through Apache or Nginx.

This .htaccess does some gzip and client side caching for Apache

https://gist.github.com/skinofstars/a53a2a6ee902f1da390b