One index with many empty fields VS Two indexes with lesser empty fields?


(Ivan Ji) #1

Hi all,

Assume I have two sets of data to be stored. The data field of these two
sets are completely different.

I am wondering what's the better option between using one index to store
the two set of data and using two index to store these two data?

If I use only one index, it will result in many fields exist in the mapping
but not really exist in the document. So when to query, does it make
performance worse? Or what's the difference?

Ideas?

Thanks a lot.

Ivan

--
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/f94dc73f-4aba-4ad3-8a1a-80bb257438f6%40googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.


(Adrien Grand) #2

Hi Ivan,

If your data sets don't have common fields, I would recommend to use
several indices. This will be more make both query execution and postings
list compression more efficient.

On Wed, Feb 5, 2014 at 11:55 AM, Ivan Ji hxuanji@gmail.com wrote:

Hi all,

Assume I have two sets of data to be stored. The data field of these two
sets are completely different.

I am wondering what's the better option between using one index to store
the two set of data and using two index to store these two data?

If I use only one index, it will result in many fields exist in the
mapping but not really exist in the document. So when to query, does it
make performance worse? Or what's the difference?

Ideas?

Thanks a lot.

Ivan

--
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/f94dc73f-4aba-4ad3-8a1a-80bb257438f6%40googlegroups.com
.
For more options, visit https://groups.google.com/groups/opt_out.

--
Adrien Grand

--
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/CAL6Z4j7rkmxtq9xWRipMA2cO7_YeZ2q%3DbK6A3S1%2B9J-nnu7dig%40mail.gmail.com.
For more options, visit https://groups.google.com/groups/opt_out.


(system) #3