I am designing an e-Commerce site with multiple warehouse. All the warehouses have same set of products. I am using ElasticSearch for my search engine. There are 40 fields each ES document. 20 out of them will differ in value per warehouse, rest 20 fields will contain same values for all warehouses.
I want to use multiple types (1 type for each warehouse) in 1 index. All of the types will have same mappings. Please advise if my approach is correct for such scenario.
Few things not clear to me,
- Will the inverted index be created only once for all types in same index?
- If new type (new warehouse) is added in future how it will be merged with the previously stored data.
- How it will impact the query time if I would have used only one type in one index.