OiO.lk Community platform!

Oio.lk is an excellent forum for developers, providing a wide range of resources, discussions, and support for those in the developer community. Join oio.lk today to connect with like-minded professionals, share insights, and stay updated on the latest trends and technologies in the development field.
  You need to log in or register to access the solved answers to this problem.
  • You have reached the maximum number of guest views allowed
  • Please register below to remove this limitation

Why is the order page on my WooCommerce store so slow?

  • Thread starter Thread starter O. Jones
  • Start date Start date
O

O. Jones

Guest
Since WooCommerce 8.9 came out, I've noticed a big slowdown when I click on an order page from WooCommerce -> Orders in my dashboard. I have a big store with many orders, and it takes many seconds to show the order page.

It's only a problem with HPOS enabled.

Query Monitor pins the blame on this slow query:

Code:
SELECT DISTINCT meta_key
FROM wp_wc_orders_meta_copy
WHERE meta_key NOT LIKE '\\_%'
ORDER BY meta_key ASC
LIMIT 30;

What can I do to speed this up?
<p>Since WooCommerce 8.9 came out, I've noticed a big slowdown when I click on an order page from WooCommerce -> Orders in my dashboard. I have a big store with many orders, and it takes many seconds to show the order page.</p>
<p>It's only a problem with HPOS enabled.</p>
<p>Query Monitor pins the blame on this slow query:</p>
<pre class="lang-sql prettyprint-override"><code>SELECT DISTINCT meta_key
FROM wp_wc_orders_meta_copy
WHERE meta_key NOT LIKE '\\_%'
ORDER BY meta_key ASC
LIMIT 30;
</code></pre>
<p>What can I do to speed this up?</p>
Continue reading...
 

Latest posts

A
Replies
0
Views
1
Ashrik Ahamed
A
A
Replies
0
Views
1
Ashrik Ahamed
A

Online statistics

Members online
1
Guests online
4
Total visitors
5
Top