Hi,
We're building quite a large shared index of resources, using Solr. The application that makes use of these resources is a multitenant one (i.e., many customers using the same index). For resources that are "private" to a customer, it's fairly easy to tag a document with their customer ID and using a FilterQuery to limit results to just their "stuff". We are soon going to be adding a large number (many tens of millions) of records that will be shared amongst customers. Not all customers will have access to the same shared resources, e.g.: * Shared resource 1: o Customer 1 o Customer 3 * Shared resource 2: o Customer 2 o Customer 1 The issue is, what is the best way to model this in Solr? Should we have multiple customer_id fields on each record, and then use the filter query as with "private" resources, or is there a better way of doing it? What happens if we need to do a bulk change - i.e. adding new customer, or a previous customer has a large change in what shared resources they have access to? Am I right in thinking that we'd need to go through every shared resource, read it, make the required change, and reindex it? I'm wondering if there's a way, instead of updating these resources directly, I could construct a set of documents that would act as a filter at query time of which shared resources to return? Kind regards, Phil John Technical Lead, Capita Software Services Knights Court, Solihull Parkway Birmingham Business Park B37 7YB Office: 0870 400 5000 Fax: 0870 400 5001 email: philj...@capita.co.uk <mailto:philj...@capita.co.uk> Part of Capita plc www.capita.co.uk <http://www.capita.co.uk> This email and any attachment to it are confidential. Unless you are the intended recipient, you may not use, copy or disclose either the message or any information contained in the message. If you are not the intended recipient, you should delete this email and notify the sender immediately. Any views or opinions expressed in this email are those of the sender only, unless otherwise stated. All copyright in any Capita material in this email is reserved. All emails, incoming and outgoing, may be recorded by Capita and monitored for legitimate business purposes. Capita exclude all liability for any loss or damage arising or resulting from the receipt, use or transmission of this email to the fullest extent permitted by law.