[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      |  Resolution:
 Keywords:                |     Focuses:
--------------------------+------------------------------

Comment (by kapil4sam):

 {{{
 SELECT DISTINCT p1.post_id
 FROM wpuo_postmeta p1
 WHERE p1.meta_value LIKE '%123456%'
 AND p1.meta_key IN
 ('_billing_address_index','_shipping_address_index','_billing_last_name','_billing_email','_order_number')
 }}}


 Above is the query which is taking too much of time.

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