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

WordPress Trac wp-trac at lists.automattic.com
Sat Aug 28 22:11:44 UTC 2010


#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:                 
-------------------------+--------------------------------------------------

Comment(by scribu):

 > 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?

 I don't think we have a policy against it. It's just that we would have to
 make sure it would work on a ''lot'' of different server setups.

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


More information about the wp-trac mailing list