[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:  critical     |  Resolution:
 Keywords:               |     Focuses:  multisite, performance
-------------------------+-------------------------------------
Description changed by SergeyBiryukov:

Old description:

> 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

New description:

 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: #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#comment:2>
WordPress Trac <https://core.trac.wordpress.org/>
WordPress publishing platform