17
hitko
5y

God I fucking hate WordPress

Today I found out a single WooCommerce site is using 20% of database CPU (for comparison, 50 other sites use only 10% between them). Upon investigation it turns out that WooCommerce loads every single product in order to do the taxonomy count. Because the data is stored as PHP-serialised values in post meta, there's no way to do a decent "SELECT count() ... GROUP BY ...". And that code came straight from the WordPress devs, no more and no less...

Comments
  • 1
    @irene Well, WooCommerce is owned by the same company as WordPress, and they offer commercial solutions based on the two...

    I'd definitely use something else, but it wasn't my decision
  • 5
    @hitko wordpress is a blog at core.

    Woocommerce is like adding NOS to a go-cart and thinking its a suitable candidate.

    im actually not suprised it would handle db queries poorly given WP isnt great at it either
  • 2
    @hitko Clarification: Woo was *acquired* by Automattic, because it was a way to capitalize on the most popular solution for a common use case. As such, most of its quirks have never really been ironed out.

    On that note, I fucking hate the way WooCommerce screws up templating in WordPress...
  • 2
    @Kaji It's been almost 4 years since, WordPress itself went through 3 major and 250 minor versions since. In that time, they could've done a complete rewrite if they weren't only focused on milking the popularity of WordPress.
  • 2
    @hitko You won’t see any argument from me on that point (you’ll see a long list of rants regarding Gutenberg in particular if you check my history). Listening to their user base is not something they do even a fraction as well as they would lead you to think, as that incident exemplifies.
  • 0
    Update: just found this https://github.com/woocommerce/... Not a single change has been made in that direction since...
  • 0
    @irene Which basically means that every big WordPress website is shit?
  • 0
    @irene I think it's literally garbage. From a purely technical standpoint it's one of worst decision one can make, imho. And I've always wondered how this monster could gain such widespread distribution. Jeez.
Add Comment