[wp-trac] [WordPress Trac] #14722: use MATCH/AGAINST instead of LIKE when querying for matching terms posts

[WordPress Trac]

#14722: use MATCH/AGAINST instead of LIKE when querying for matching terms posts
-------------------------+--------------------------------------------------
 Reporter:  pgentoo      |       Owner:                 
     Type:  enhancement  |      Status:  new            
 Priority:  normal       |   Milestone:  Awaiting Review
Component:  Performance  |     Version:  3.0.1          
 Severity:  normal       |    Keywords:                 
-------------------------+--------------------------------------------------
Changes (by pgentoo):

 * cc: pgentoo (added)


Comment:

 yeah it must be by a plugin.  I see a fulltext index called
 "posts_related" on the table, which indexes both of the columns in
 question.

 I would suggest changing to a large VARCHAR and indexing it, but the low
 minimum requirements for wordpress (mysql 4.1.2) make that not feasible
 because of the 255 character limit on old versions.

 Are you guys against using FULLTEXT indexes in WordPress?  Or just haven't
 added any to date?

-- 
Ticket URL: <http://core.trac.wordpress.org/ticket/14722#comment:6>
WordPress Trac <http://core.trac.wordpress.org/>
WordPress blogging software