My design is like this at the moment: Documents in general has a relation to each other.
So, a document has a id, some attributes and a multivalue-field "navigateTo". E.g. Document1: id1, some attributes, naviagteToAllDocumentsWhenColor:red, navigateTo: id2, id3 Document2: id2, some attributes, color:red, navigateTo: id1 (backlink) Document3: id3, some attributes, color:red, navigateTo: id1 (backlink) Document4: id5, some attributes, color:black, navigateTo: My first problem is, that when I re-import document3 I have to load all documents in cache which has a relation to my documents, because of my color is red. Especially when my color is not red anymore, I have to update document1 und delete the relation to document3. Always do the queries in order to find out which documents I have to update, the to load and update it, costs a lot of performance. That’s why I changed the design. I don’t do all relations anymore at importime. I have some serialized hashmaps and store and update them outide of solr. In this maps I have the informations which documents I related to a document. I have all ids. But then I have this problem now, that this can be up to 20.000 ids. So I think this is impossible to load the with OR...OR...OR. It is a bit complicated to explain...i am using solr 3.6.1. I think with solr 4 they have this LINK feature, where can join other queries. Not sure if this would fix my problem. REGARDS, Uwe -- View this message in context: http://lucene.472066.n3.nabble.com/Pls-help-Very-long-query-what-to-do-tp4021606p4021684.html Sent from the Solr - User mailing list archive at Nabble.com.
