Lets say that I was providing a service to customers that requires customers to sign up to use my service. I'm also using elasticsearch to store analytics data about each customer. The number of documents recorded for each customer is completely arbitrary (some customers may have 1million + documents, some may have less than 1000).
*Which solution would be better?* 1. Give each customer their own index 2. Put all customer's data into a single index *Argument for solution #1:* In my personal tests, I can see that if I have 1million documents in index A, and 1000 documents in index B, then queries run on index B aren't being slowed down by the amount of documents in index A. However, when I put them all into the same index and separate them by a unique key, then index B's queries are slowed down by the number of documents in index A. *Argument for solution #2: *I've only heard that having an arbitrary number of indicies is bad for performance in the long term. -- You received this message because you are subscribed to the Google Groups "elasticsearch" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To view this discussion on the web visit https://groups.google.com/d/msgid/elasticsearch/15de33c8-d0e5-484f-9c16-f68be2bdb005%40googlegroups.com. For more options, visit https://groups.google.com/d/optout.
