Hi Stennie.
In my case I have different properties I need to query for and I don’t think I have any way to get around my queries being scatter-gather. Additionally, although I have a lot of data that is mostly stale, there is no way for me to know which data is stale. Any of it can become relevant at any time. The good news is that the queries will be executed by background services so ms responses aren’t critical.
There are clearly too many factors for a non-expert like myself to find the best model so I think professional advice is needed.
Thanks.
Tim