[wp-trac] [WordPress Trac] #51769: Full-text search support

[WordPress Trac]

#51769: Full-text search support
--------------------------------------+------------------------------
 Reporter:  zieladam                  |       Owner:  (none)
     Type:  enhancement               |      Status:  new
 Priority:  normal                    |   Milestone:  Awaiting Review
Component:  Database                  |     Version:
 Severity:  normal                    |  Resolution:
 Keywords:  dev-feedback 2nd-opinion  |     Focuses:
--------------------------------------+------------------------------

Comment (by azaozz):

 Replying to [comment:14 zieladam]:

 > I haven't found any INSERT benchmarks for the fulltext feature though...
 > This aligns with the concerns expressed by @barry. Unfortunately, there
 doesn't seem to be many charts and tables out there.

 Yea, heard about Barry's concerns too. Another concern may be when adding
 the index. Normally updates to the DB happen after installing a new
 WordPress version (the familiar "Database update required" screen),
 however creating that FULLTEXT index may need more time/different approach
 for sides with a lot of posts.

 Perhaps another good test idea would be to see if a "normal" request would
 be sufficient to add the index for a very large table. Then come up with a
 solution if this causes PHP to time out of MySQL runs out of resources, or
 any other possible problems.

 > As for the disk space: I did a few quick searches and found that the
 index could take somewhere between 10% and 80% of the size of the text.

 Considering that `wp_posts` is the largest table, and that most of that
 size is for `post_content`, such size increase would be significant.
 Still, not sure if that's a bug drawback considering the overall
 performance improvements.

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