# The Max Number of Filelds ES Can Support **URL:** \ **Category:** Elasticsearch\ **Created:** [September 19, 2014, 7:53am UTC](https://discuss.elastic.co/t/the-max-number-of-filelds-es-can-support/19879 "2014-09-19T07:53:34Z")\ **Posts on this page:** 5\ **Page:** 1
**Author:** ![xiehaiwei](https://avatars.discourse-cdn.com/v4/letter/x/6de8d8/32.png) [@xiehaiwei](https://discuss.elastic.co/u/xiehaiwei)\ **Post date:** [September 19, 2014, 7:53am UTC](https://discuss.elastic.co/t/the-max-number-of-filelds-es-can-support/19879/1 "2014-09-19T07:53:34Z")
HI, ``` In my case , there are about five thousand fields, Can ES support ``` this? How do the number of fields affect the speed of searching? Thanks. terrs -- 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/a30b4502-9a50-4f84-bee1-c5519e47c3bd%40googlegroups.com](https://groups.google.com/d/msgid/elasticsearch/a30b4502-9a50-4f84-bee1-c5519e47c3bd%40googlegroups.com). For more options, visit [https://groups.google.com/d/optout](https://groups.google.com/d/optout). ---
**Author:** ![jprante](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/jprante/32/44941_2.png) [@jprante](https://discuss.elastic.co/u/jprante)\ **Post date:** [September 19, 2014, 11:27am UTC](https://discuss.elastic.co/t/the-max-number-of-filelds-es-can-support/19879/2 "2014-09-19T11:27:40Z")
A search is independent from the number of fields as long as you do not search over this number of fields. You can create as much fields as your memory und resources will let you do so. Jörg On Fri, Sep 19, 2014 at 9:53 AM, [xiehaiwei@gmail.com](mailto:xiehaiwei@gmail.com) wrote: > HI, > > ``` > In my case , there are about five thousand fields, Can ES support > > ``` > > this? How do the number of fields affect the speed of searching? > > Thanks. > terrs > > -- > 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/a30b4502-9a50-4f84-bee1-c5519e47c3bd%40googlegroups.com](https://groups.google.com/d/msgid/elasticsearch/a30b4502-9a50-4f84-bee1-c5519e47c3bd%40googlegroups.com) > [https://groups.google.com/d/msgid/elasticsearch/a30b4502-9a50-4f84-bee1-c5519e47c3bd%40googlegroups.com?utm\_medium=email&utm\_source=footer](https://groups.google.com/d/msgid/elasticsearch/a30b4502-9a50-4f84-bee1-c5519e47c3bd%40googlegroups.com?utm_medium=email&utm_source=footer) > . > For more options, visit [https://groups.google.com/d/optout](https://groups.google.com/d/optout). -- 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/CAKdsXoFQDjNumnwABzXYUyJ1dVuTynPcut2k\_SUszmRe-WuMPw%40mail.gmail.com](https://groups.google.com/d/msgid/elasticsearch/CAKdsXoFQDjNumnwABzXYUyJ1dVuTynPcut2k_SUszmRe-WuMPw%40mail.gmail.com). For more options, visit [https://groups.google.com/d/optout](https://groups.google.com/d/optout). ---
**Author:** ![xiehaiwei](https://avatars.discourse-cdn.com/v4/letter/x/6de8d8/32.png) [@xiehaiwei](https://discuss.elastic.co/u/xiehaiwei)\ **Post date:** [September 20, 2014, 3:14am UTC](https://discuss.elastic.co/t/the-max-number-of-filelds-es-can-support/19879/3 "2014-09-20T03:14:57Z")
Hi, ``` Actually, search need go over all fields, every field has special ``` definition, the number of fields is too big to remember, I need search all fields for any keywords, return matched docs and field name to request. ``` Why so many fields, cause the data come from tables of database. ``` Client want a system to search any data conveniently. ``` There are other problems like, search results from two tables need do ``` a join-like operation. ``` These requirements exceed ES capcacity, I am not sure. ``` Thanks. > A search is independent from the number of fields as long as you do not > search over this number of fields. > > You can create as much fields as your memory und resources will let you do > so. > > Jörg -- 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/93c6af1d-0f3b-4243-b79c-b0e682e4520c%40googlegroups.com](https://groups.google.com/d/msgid/elasticsearch/93c6af1d-0f3b-4243-b79c-b0e682e4520c%40googlegroups.com). For more options, visit [https://groups.google.com/d/optout](https://groups.google.com/d/optout). ---
**Author:** ![Nelson\_Jeppesen](https://avatars.discourse-cdn.com/v4/letter/n/6de8d8/32.png) [@Nelson\_Jeppesen](https://discuss.elastic.co/u/Nelson_Jeppesen)\ **Post date:** [September 22, 2014, 1:09am UTC](https://discuss.elastic.co/t/the-max-number-of-filelds-es-can-support/19879/4 "2014-09-22T01:09:00Z")
Are you using the \_all field in your mapping? I think that could work. That will make all data searchable, without having to worry about particular fields. Logstash does this for an example. [https://github.com/elasticsearch/logstash/blob/master/lib/logstash/outputs/elasticsearch/elasticsearch-template.json](https://github.com/elasticsearch/logstash/blob/master/lib/logstash/outputs/elasticsearch/elasticsearch-template.json) On Friday, September 19, 2014 8:14:57 PM UTC-7, [xieh...@gmail.com](mailto:xieh...@gmail.com) wrote: > Hi, > > ``` > Actually, search need go over all fields, every field has special > > ``` > > definition, the number of fields is too big to remember, > I need search all fields for any keywords, return matched docs and field > name to request. > > ``` > Why so many fields, cause the data come from tables of database. > > ``` > > Client want a system to search any data conveniently. > > ``` > There are other problems like, search results from two tables need do > > ``` > > a join-like operation. > > ``` > These requirements exceed ES capcacity, I am not sure. > > ``` > > Thanks. > > > A search is independent from the number of fields as long as you do not > > search over this number of fields. > > > > You can create as much fields as your memory und resources will let you > > do so. > > > > Jörg -- 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/f502ad18-2c3c-46f6-bda4-dc30d0b79564%40googlegroups.com](https://groups.google.com/d/msgid/elasticsearch/f502ad18-2c3c-46f6-bda4-dc30d0b79564%40googlegroups.com). For more options, visit [https://groups.google.com/d/optout](https://groups.google.com/d/optout). ---
**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:00am UTC](https://discuss.elastic.co/t/the-max-number-of-filelds-es-can-support/19879/5 "2017-07-06T01:00:48Z")