[wp-trac] [WordPress Trac] #33885: meta_form performs a potentially expensive query

[WordPress Trac]

#33885: meta_form performs a potentially expensive query
----------------------------+------------------------------
 Reporter:  jorbin          |       Owner:
     Type:  defect (bug)    |      Status:  new
 Priority:  normal          |   Milestone:  Awaiting Review
Component:  Administration  |     Version:
 Severity:  normal          |  Resolution:
 Keywords:                  |     Focuses:  performance
----------------------------+------------------------------
Description changed by DH-Shredder:

Old description:

> This is a follow-up to #24498 and the research that @tollmanz did on the
> query used in meta_form.  To summerize:
>
> The query in meta_form can be incredibly slow on sites with a lot of post
> meta.
>
> The solution to me seems to be to cache the query and update the cache of
> meta to use everytime a new piece of post_meta is saved. This will
> prevent the query from needing to be run on sites with a persistant
> cache.

New description:

 This is a follow-up to #24498 and the research that @tollmanz did on the
 query used in meta_form.  To summarize:

 The query in meta_form can be incredibly slow on sites with a lot of post
 meta.

 The solution to me seems to be to cache the query and update the cache of
 meta to use every time a new piece of post_meta is saved. This will
 prevent the query from needing to be run on sites with a persistent cache.

--

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