Which is the best way to create types in terms of performance in elasticsearch

i have a RDBMS tables having multiple columns and its hetrogenous and need
to create an index in elasticsearch from these tables. So which is the best
practise intems of creation of types in elasticsearch. i was thinking about
the multiple option 1) create types as same as rdbms tables and add
documents as same as records in table 2) create a type with two fileds, in
which one of the field for identification of that document and other field
will be the concatenation of tables columns vales. So in this way only two
fileds will be there across the all tables and search on the one field.

So could you let me know, which is the best way to create the types. please
let me know, if need more info.

--
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.
To view this discussion on the web visit https://groups.google.com/d/msgid/elasticsearch/ff801563-1a96-45e5-8c7d-e67f47ae1269%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

Could anybody let me know the suggestion :slight_smile:

On Tuesday, April 14, 2015 at 9:49:20 AM UTC+5:30, binu wrote:

i have a RDBMS tables having multiple columns and its hetrogenous and need
to create an index in elasticsearch from these tables. So which is the best
practise intems of creation of types in elasticsearch. i was thinking about
the multiple option 1) create types as same as rdbms tables and add
documents as same as records in table 2) create a type with two fileds, in
which one of the field for identification of that document and other field
will be the concatenation of tables columns vales. So in this way only two
fileds will be there across the all tables and search on the one field.

So could you let me know, which is the best way to create the types.
please let me know, if need more info.

--
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.
To view this discussion on the web visit https://groups.google.com/d/msgid/elasticsearch/e5bc26b1-0cf6-43fb-aca2-edf35f55967b%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.