Elasticsearch design consideration


#1

Hi all
Hope I post in the right section.
We have a small design problem, and I would like to have some advice.

  • We have a main index containing thousands of items.
  • We have thousands of users.
  • Each users can have a part or all the items of the main index.
  • Each users can add some informations (searchable) to this items.
    For the moment, we have created an index per user. but it multiply the number of shards, and result some memory failure.

All advice are good !
Thanks in advance for your help


(Mark Walkom) #2

So you have per user items, but then that user can also access other items belonging to other users?


#3

Thanks for your answer.
nope.
Other user can't search the user index. Users share no datas between them


(Mark Walkom) #4

Oh right, then use routing with a single index.
You may need to move large users out into their own index though.


#5

Basicaly
We just user just add one information, the price they sell the item.
So even large users have lot in common with small one.
But I don't understand how routing will help us,because we have to store the price


(Mark Walkom) #6

Routing just forces the data for a given user into the same shard, which makes search faster as you always go to that shard.


(system) #7