[wp-trac] [WordPress Trac] #57283: Postmeta - Performance Improvement - Woocommerce

[WordPress Trac]

#57283: Postmeta - Performance Improvement - Woocommerce
--------------------------+-----------------------------
 Reporter:  kapil4sam     |      Owner:  (none)
     Type:  defect (bug)  |     Status:  new
 Priority:  normal        |  Milestone:  Awaiting Review
Component:  General       |    Version:  6.1.1
 Severity:  critical      |   Keywords:
  Focuses:                |
--------------------------+-----------------------------
 Hi Team,

 Struggling since almost a month to find the solution for slow search in
 woocoomerce. Tried verious different things like speed up index mysql.
 Changing mysql version from 5.7 to 8.x.
 Updated index - added high performance keys for post meta table.

 When backend team search for orders from woocommerce-orders tab - it takes
 almost 3 min to get the results.

 Looking for inputs from wordpress community and help for the same.

-- 
Ticket URL: <https://core.trac.wordpress.org/ticket/57283>
WordPress Trac <https://core.trac.wordpress.org/>
WordPress publishing platform