[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:  new
 Priority:  normal       |  Milestone:  Awaiting Review
Component:  Query        |    Version:  4.0
 Severity:  normal       |   Keywords:
  Focuses:               |
-------------------------+-----------------------------
 Hi all,
 i manage a WordPress site that has about 100k posts.
 It is configured under a dedicated Server and the performance are good
 except when users use the search function.

 We have the same problem resolved in this ticket:

 https://core.trac.wordpress.org/ticket/10964

 but our WordPress is 4.0 version and the patch file attached isn't useful
 for us.

 We monitored Db performance with mytop and we found this query very heavy:

 SELECT SQL_CALC_FOUND_ROWS wp_posts.ID FROM wp_posts WHERE 1=1 AND
 (((wp_posts.post_title LIKE '%festival.\\%20ombre%') OR
 (wp_posts.post_con...

 Can you help us to patch this problem and find the best solution for
 improving performance?

 Best regards

 WpSEO

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