Hey, I don't think that a cake implementation is needed Zend_Search_Lucene is awesome, and it doesn't have any dependencies from Zend Framework. I'm building(finishing) a behavior wraping Zend_Search_Lucene + a console tool for index generation (primary for cookbook) its still alpha but it works. it will be released soon.
As for the comparison - i planed to do some but with my basic tests - it outperforms Mysql FULLTEXT couple times. ( LIKE %a% is way slower) than FULLTEXT. On Tue, Jun 10, 2008 at 8:11 PM, Jonathan Snook <[EMAIL PROTECTED]> wrote: > > 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. >> > >> > > > > -- Marcin Domanski http://kabturek.info --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "CakePHP" group. To post to this group, send email to [email protected] 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 -~----------~----~----~----~------~----~------~--~---
