Best approach between increasing index properties size or large no of nested document

I have a user document

User has n properties of his own which is around 200.
User has few nested properties like his activities, products, brands etc.

Case I,
If I put all data in flat way, not creating any nested objects, it
increases index properties size to around 50K.

Case II,
If I put all data in nested objects, it increases no of Document to around
300 per user. In this case total documents grows in billions.

Case III,
If I take mixed approach, It will make index properties size of around 500
and few nested objects. Here document size of user is around 45.

I have to take decision on choosing best way on above.

I appreciate if you suggest any other way which is appropriate in my
situation.

--
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/98d38b20-3645-48a7-98ea-385f186c3c90%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

hh

On Tuesday, 23 December 2014 11:52:22 UTC+5:30, sandeep kaushal verma wrote:

I have a user document

User has n properties of his own which is around 200.
User has few nested properties like his activities, products, brands etc.

Case I,
If I put all data in flat way, not creating any nested objects, it
increases index properties size to around 50K.

Case II,
If I put all data in nested objects, it increases no of Document to
around 300 per user. In this case total documents grows in billions.

Case III,
If I take mixed approach, It will make index properties size of around 500
and few nested objects. Here document size of user is around 45.

I have to take decision on choosing best way on above.

I appreciate if you suggest any other way which is appropriate in my
situation.

--
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/e1903fdf-3e5c-4228-994a-945ea7001e4d%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.