Hi Marco, I am also using Lucene and honestly I doubt that you will reach the limit so easily. You should NOT store the whole record in the database, but preferably add the text fields as unstored which means they get index but will not increase the size of the index significantly. Just store a PK of your filed and on suche use it to retrieve the data again from the database and not from lucene. (I do not know if Carls plugin works like that, but thats how my implementation of lucene works.
You can read my blog about my variant (composition of multiple preworks :-)) http://www.hma-info.de/blog/2007/09/15/integrating-lucene-into-symfony-a-wra p-up/ Grüße aus Ratingen nach Meerbusch .: Fabian _____ From: [EMAIL PROTECTED] om [mailto:[EMAIL PROTECTED] groups.com] On Behalf Of Marco Schierhorn Sent: Mittwoch, 17. Oktober 2007 13:07 To: [email protected] Subject: [symfony-users] Fulltext Search Lucene / Sphinx / MyISAM ? Hey, i would like to say that i love this framework. It saves so much time in developing. Its great. So, my problem is now to create a Fulltext search for several tables. ( Member Profiles, a big Forum, Messages, Groups, Classifieds ) I did use the MyISAM Fulltext search before, but we re growing each day more and more, so it will be very slow in the future with many rows to search. Also, I didnt want to use MyISAM Tables anymore, so I did switch to InnoDB. Ive found the sfLucenePlugin. It seems to be easy to implement and to be very fast. But I read in the manual that it only provides indexes up to 2 GByte. When I take a look at my Forum Posts I think the index could get bigger than the max of 2 GByte. Not now, but maybe next year. So I took a look on other Fulltext Search Projects like Sphinx. Maybe Sphinx could fit my needs a little bit better. The only thing I didnt like, is the fact that you dont have a real live index / reindex on Sphinx. ( delta / main index ). Also, Ive found some benchmarks (google) where Sphinx was much faster than Lucene or MyISAM Fulltext search ( I didnt expect something different ) What are your thoughts on that? Maybe you had the same problem / decision in the past? Any suggestions would be really appreciated. Thanks a lot. Regards, Marco -- Marco Schierhorn Technical Director ------------------------------------------------------------------- ESV Media GmbH Meerbuscher Str. 64-78 | 40670 Meerbusch Tel. +49 (0)2159 / 9297-930 | Fax. +49 (0)2159 / 9297-931 Mobil +49 (0)173 / 99 37 000 www.esv-group.de | [EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]> Geschäftsführer: Heinz Eissing Amtsgericht | Neuss HRB 12902 Diese E-Mail enthält vertrauliche und/oder rechtlich geschützte Informationen. Wenn Sie nicht der richtige Adressat sind oder diese E-Mail irrtümlich erhalten haben, informieren Sie bitte sofort den Absender und vernichten Sie diese Mail. Das unerlaubte Kopieren sowie die unbefugte Weitergabe dieser E-Mail ist nicht gestattet. This e-mail may contain confidential and/or privileged information. If you are not the intended recipient (or have received this e-mail in error) please notify the sender immediately and destroy this e-mail. Any unauthorised copying, disclosure or distribution of the material in this e-mail is strictly forbidden. --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "symfony users" 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/symfony-users?hl=en -~----------~----~----~----~------~----~------~--~---
