# How does ES scale with many fields? **URL:** \ **Category:** Elasticsearch\ **Created:** [January 22, 2014, 12:38pm UTC](https://discuss.elastic.co/t/how-does-es-scale-with-many-fields/15358 "2014-01-22T12:38:12Z")\ **Posts on this page:** 3\ **Page:** 1
**Author:** ![Bernhard\_Berger](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/bernhard_berger/32/833_2.png) [@Bernhard\_Berger](https://discuss.elastic.co/u/Bernhard_Berger)\ **Post date:** [January 22, 2014, 12:38pm UTC](https://discuss.elastic.co/t/how-does-es-scale-with-many-fields/15358/1 "2014-01-22T12:38:12Z")
I want to save a filter over a category-field (with about 5 distinct values) of my Elasticsearch documents and ask me if I could use different field names for every category instead. F.ex. instead of the fields: "category", "date" I would use "dateRed", "dateBlue", "dateGreen" So to get all dates from category red I could use "dateRed" instead of "date && Filter(category=Red)". I know, I could use different types for every category, but the documents share some common fields together. Does Elasticsearch scale well when I use lot of different fields (~100 fields) in my documents or is it better to keep the field number small? -- 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 [elasticsearch+unsubscribe@googlegroups.com](mailto:elasticsearch+unsubscribe@googlegroups.com). To view this discussion on the web visit [https://groups.google.com/d/msgid/elasticsearch/52DFBBB4.8090202%40gmail.com](https://groups.google.com/d/msgid/elasticsearch/52DFBBB4.8090202%40gmail.com). For more options, visit [https://groups.google.com/groups/opt\_out](https://groups.google.com/groups/opt_out). ---
**Author:** ![Binh\_Ly](https://avatars.discourse-cdn.com/v4/letter/b/ce7236/32.png) [@Binh\_Ly](https://discuss.elastic.co/u/Binh_Ly)\ **Post date:** [January 22, 2014, 2:43pm UTC](https://discuss.elastic.co/t/how-does-es-scale-with-many-fields/15358/2 "2014-01-22T14:43:26Z")
Bernhard, I would suggest to experiment and see what you find. I've created indexes with 10 fields, and others with hundreds of fields. Performance should not be a problem (but experiment anyway). I would be more concerned with maintainability/usability of your index, i.e. is it easier for you/your clients to query your index using normalized fields or denormalized fields. On Wednesday, January 22, 2014 7:38:12 AM UTC-5, Bernhard Berger wrote: > I want to save a filter over a category-field (with about 5 distinct > values) of my Elasticsearch documents and ask me if I could use > different field names for every category instead. > > F.ex. instead of the fields: > "category", "date" > I would use > "dateRed", "dateBlue", "dateGreen" > > So to get all dates from category red I could use "dateRed" instead of > "date && Filter(category=Red)". > > I know, I could use different types for every category, but the > documents share some common fields together. > > Does Elasticsearch scale well when I use lot of different fields (~100 > fields) in my documents or is it better to keep the field number small? -- 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 [elasticsearch+unsubscribe@googlegroups.com](mailto:elasticsearch+unsubscribe@googlegroups.com). To view this discussion on the web visit [https://groups.google.com/d/msgid/elasticsearch/19f2b153-cd7a-4732-9a2c-f7e3cc7328df%40googlegroups.com](https://groups.google.com/d/msgid/elasticsearch/19f2b153-cd7a-4732-9a2c-f7e3cc7328df%40googlegroups.com). For more options, visit [https://groups.google.com/groups/opt\_out](https://groups.google.com/groups/opt_out). ---
**Author:** ![system](https://us1.discourse-cdn.com/elastic/original/3X/1/a/1ac57faf039f6b580b3f104ef42a2a89e41014de.png) [@system](https://discuss.elastic.co/u/system)\ **Post date:** [July 6, 2017, 1:55am UTC](https://discuss.elastic.co/t/how-does-es-scale-with-many-fields/15358/3 "2017-07-06T01:55:23Z")