0

MariaDB 10.3

I am investigating a Wordpress / Woocommerce installation, which is quite slow. I threw the slow log into ChatGPT, which suggested adding indexes to the status column of the wp_wc_order_stats table. I checked to see if there weren't indexes already, and sure enough; there were (on more columns than just the status column in fact)

So I used EXPLAIN like this: EXPLAIN SELECT DISTINCT status FROM wp_wc_order_stats;

which resulted in the table

explain output

ChatGPT told me 'Using temporary' indicated that the index wasn't used. What can I do to fix this?

2
  • 1
    Googling woocommerce add index yields a lot of tips for improving performance. Maybe you try some of these. Commented Feb 17 at 11:04
  • You didn't really read the question. I have an index, but somehow it doesn't seem to be used during queries. That's not Woocommerce specific and telling someone 'to just Google it' kind of defies the purpose of answering here at all. Commented Feb 17 at 19:37

0

You must log in to answer this question.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.