"mikezzz" wrote : anonymous wrote : or maybe implement a Lucene index | | This is not such a bad idea. Perhaps not to support the Mail API but to support protocols that require search. We could use lucene, or roll our own that will allow joins directly from the index to the message rows. I think this could be a POC task for M4. If it will be useful, implement in M5.
My temptation is to hold of indexing for M5. The reason being is that IMAP has various search functions that we'll be half-impelemnting in M4. These will dictate things about indexing. My only problem with Lucene is that it may be difficult to index concurrently enough to not make writes really slow and secondly we'll probably fragment the hell out of things. We may need a different sort of index. All databases doing this (http://www.oracle.com/technology/products/text/index.html in particular see the technical whitepaper) is an ideal. However supporting that in a multi-dabase fashion is going to be a real challenge. "oracle technical whitepaper" wrote : | anonymous wrote : | | SELECT score(1), product_id, product_name | | FROM product_information | | WHERE CONTAINS | | (product_description, 'monitor NEAR "high resolution"', 1) > 0 | | ORDER BY score(1) DESC; | | | | However with MySQL gaining triggers and PostgreSQL having them, it is possible that we'll be able to do database packages to accomplish this. | | Thoughts? View the original post : http://www.jboss.org/index.html?module=bb&op=viewtopic&p=3870755#3870755 Reply to the post : http://www.jboss.org/index.html?module=bb&op=posting&mode=reply&p=3870755 ------------------------------------------------------- SF email is sponsored by - The IT Product Guide Read honest & candid reviews on hundreds of IT Products from real users. Discover which products truly live up to the hype. Start reading now. http://ads.osdn.com/?ad_id=6595&alloc_id=14396&op=click _______________________________________________ JBoss-Development mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/jboss-development
