Re: Multiply connected data search

2025-01-04 Thread Nikola Smolenski
On Mon, Dec 30, 2024 at 6:13 PM Andrew Witt wrote: > First, long experience tells me to avoid field names like "other_ids", > because what "other" means is context-dependent. Sure, it's all clear to > you now, but would it be clear to someone else? Will it be clear to you a > year from now? Wh

Re: Multiply connected data search

2025-01-04 Thread Walter Underwood
The elegant solution in Solr is a flat schema. You are not doing “database design”. You are doing search schema design. They are very different. Do. Not. Do. Joins. List the fields which need to be searched. Make those indexed. For a small amount of data (under a million docs), it can help debu

Re: Multiply connected data search

2025-01-04 Thread Walter Underwood
The elegant solution in Solr is a flat schema. You are not doing “database design”. You are doing search schema design. They are very different. Do. Not. Do. Joins. List the fields which need to be searched. Make those indexed. For a small amount of data (under a million docs), it can help debu