[wp-trac] [WordPress Trac] #39358: Media search speed has been dramatically reduced

[WordPress Trac]

#39358: Media search speed has been dramatically reduced
--------------------------+------------------------------
 Reporter:  merts         |       Owner:  joemcgill
     Type:  defect (bug)  |      Status:  reviewing
 Priority:  normal        |   Milestone:  Awaiting Review
Component:  Media         |     Version:  4.7
 Severity:  normal        |  Resolution:
 Keywords:                |     Focuses:  performance
--------------------------+------------------------------

Comment (by dd32):

 Replying to [comment:10 merts]:
 > @dd32 Maybe I can suggest another option:

 A table per field will always be faster, but where do you draw the line?
 Bluntly, we're not going to take that route.
 Metadata stored in postmeta is fine and having a thousand post metas per
 post isn't an issue - it just needs to be recognised that you can't query
 globally by postmeta, and it should only be used to narrow an already
 reduced data set.

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