Thanks Karl, sorry I was on business vacation and could not reply soon.
Ok, I want to index my database and search through the indexes, and the tables in database are more than 50 and it's hard to joining them and then indexing. so I was thinking of indexing each table in a document but in one index file and then make relations between them I know that Lucene is not a relational database but it really helps us to improve accessing our information and even generating reports. Even if this feature decline the performance, still it is better than generating reports from SQL statements and the speed up accessing information. now our users are very satisfied by this. but we need to create some relationship between documents. On 4/11/07, karl wettin <[EMAIL PROTECTED]> wrote:
11 apr 2007 kl. 11.19 skrev Mohammad Norouzi: > is it possible (or a trickery way) to search with a given query in > which we > can set an equality for two fields > for example: > > Document: > field1 field2 field3 field4 > > Query: > field1:"test phrase" AND field2:"test" AND field3:field4 > > in this query we said that do search where field3 is equal to > field4 ... > (and rest of the query) > > if it is not possible, can we ask it as a new feature from Lucene > developers? It could probably be done, but would be quite an expensive query to place. However, a request like this usually tiggers questions about the design of an index with such needs. There is probably a better solution. Start by telling us about the data you have inserted to the index, and what it is you try to achieve. In essence, Lucene is not a relational database. -- karl --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
-- Regards, Mohammad
