[wp-trac] [WordPress Trac] #52360: speed up update_meta_cache with easy fix

[WordPress Trac]

#52360: speed up update_meta_cache with easy fix
-----------------------------------+------------------------------
 Reporter:  vladislavdavarashvili  |       Owner:  (none)
     Type:  enhancement            |      Status:  new
 Priority:  normal                 |   Milestone:  Awaiting Review
Component:  Options, Meta APIs     |     Version:
 Severity:  normal                 |  Resolution:
 Keywords:  has-patch              |     Focuses:  performance
-----------------------------------+------------------------------

Comment (by iflairwebtechnologies):

 Thanks for the feedback regarding behavior changes.

 I agree that unconditional ordering could affect edge cases relying on
 current meta order.

 One possible compromise could be limiting ORDER BY meta_id ASC to
 scenarios where multiple object IDs are requested, where ordering is less
 likely to be relied upon, or restricting this optimization to post meta
 only.

 Happy to explore a constrained approach if this direction makes sense.

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