*Given:* - 1 database per client (business customer) - 5000 clients - Clients have between 2 to 2000 users (avg is ~100 users/client) - 100k to 10 million records per database - Users need to search those records often (it's the best way to navigate their data)
*The Question:* How would you setup Solr (or Lucene) search so that each client can only search within its database? How would you setup the index(es)? Where do you store the index(es)? Would you need to add a filter to all search queries? If a client cancelled, how would you delete their (part of the) index? (this may be trivial--not sure yet) I asked this question on StackOverflow.com<http://stackoverflow.com/questions/2707055/how-to-setup-lucene-search-for-a-b2b-web-app>. I would like it better, if you answered there. Thanks.
