Uwe, Do you think BlockJoin can help you http://blog.mikemccandless.com/2012/01/searching-relational-content-with.html? Do your docs forms parent-child blocks? How often you need to reindex particular doc?
On Wed, Nov 21, 2012 at 9:54 PM, uwe72 <uwe.clem...@exxcellent.de> wrote: > 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. > -- Sincerely yours Mikhail Khludnev Principal Engineer, Grid Dynamics <http://www.griddynamics.com> <mkhlud...@griddynamics.com>
