[wp-trac] [WordPress Trac] #30416: Improving Performance for Site with 100k posts

[WordPress Trac]

#30416: Improving Performance for Site with 100k posts
-------------------------+--------------------------
 Reporter:  WpSEOit      |       Owner:
     Type:  enhancement  |      Status:  closed
 Priority:  normal       |   Milestone:
Component:  Query        |     Version:  4.0
 Severity:  critical     |  Resolution:  invalid
 Keywords:               |     Focuses:  performance
-------------------------+--------------------------
Changes (by boonebgorges):

 * status:  new => closed
 * focuses:  multisite, performance => performance
 * resolution:   => invalid
 * milestone:  Awaiting Review =>


Comment:

 Thanks for the report, WpSEOit.

 At a glance, it looks like this is a search query
 (example.com/?s=festival.%20hombre). This kind of `LIKE` query against a
 very large data set is going to be fairly slow, especially if your post
 content is quite large. This is a limitation of MySQL, and there's not
 much that WordPress itself can do to get around it. See #21688, #7394 for
 some related discussions.

 There are WP plugins that improve search performance in various ways.
 https://wordpress.org/plugins/relevanssi/ is a popular one. Realistically,
 when your site has amassed a certain amount of content, the only way to
 get truly performant searching is to use an external appliance that's
 designed for search: something like Sphinx or ElasticSearch (along with
 corresponding WP integration plugins: https://wordpress.org/plugins
 /wordpress-sphinx-plugin/, https://wordpress.org/plugins/fantastic-
 elasticsearch/ are two examples).

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