I think it may have been referring to the use of LIKE queries compared to FULLTEXT queries. And to that, I'm not sure which is faster although I assume the latter. It may be interesting to look at Lucene. (btw: a CakePHP implementation of Lucene would be awesome.)
On Tue, Jun 10, 2008 at 12:33 PM, SeanW <[EMAIL PROTECTED]> wrote: > > "If users commonly search 'product names' you may want to make that > field a FULLTEXT index. This will make searches much faster." > > Have you verified this? Using a fulltext index requires the "MATCHES" > function in the SQL, it doesn't get used if you do a "WHERE foo=" type > query. I don't see any code in CakePHP that uses the MATCHES function. > > > --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "CakePHP" group. To post to this group, send email to cake-php@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cake-php?hl=en -~----------~----~----~----~------~----~------~--~---