I'm trying to figure out if Solr is the right solution for a problem I'm facing. I have 2 data entities: P(arent) & C(hild). P contains up to 100 instances of C. I need to expose an interface that searches attributes of entity C, but displays them grouped by parent entity, P. I need to include facet counts in the result, and the counts are based on P.
My first solution was to create 2 Solr instances: one for each entity. I would have to execute 2 queries each time: 1) get a list of matching P's based on a query of the C instance (facet by P ID in C instance to get unique list of P's), then 2) get all P's by ID, including facet counts, etc. The problem I face with this solution is that I can have many matching P's (10,000+), so my second query will have many (10,000+) constraints. My second (and current) solution is to create a single instance, and flatten all C attributes into the appropriate P record using dynamic fields. For example, if C has an attribute CA, then I have a dynamic field in P called CA*. I name this field incrementally based on the number of C's per P (CA1, CA2, ...). This works, except that each query is very long (CA1:condition OR CA2: condition ...). Neither solution is ideal. I'm wondering if I'm missing something obvious, or if I'm using the wrong solution for this problem. Any insight is appreciated. Wojtek -- View this message in context: http://www.nabble.com/Searching-and-Displaying-Different-Logical-Entities-tp25156301p25156301.html Sent from the Solr - User mailing list archive at Nabble.com.
