Re: SQL-Like Join in Lucene

2006-08-10 Thread hu andy
4. Search for records with filter. if the filter returns a lot of ids, it willn' t be fast. Recently I have a test. I customized a filter which get a list of ids from a mysql database table of size 5000. Then I invoke the search(query, filter, hitcollector), I took me more than 40s to retrieve th

SQL-Like Join in Lucene

2006-08-10 Thread Aleksei Valikov
Hi. I'm investigating a possibility to make a "join" in Lucene/Compass. Here's the thread: http://forums.opensymphony.com/thread.jspa?threadID=39685&tstart=0 I have records m:m entities. Entities hold indexed information. Records consist of entities. One entity may belong to many records. I w