Index by Category

Elastic Stack Elasticsearch
1

Hi there,

I have nearly 1M docs in my index and 4 nodes that performing search and fecthes. Query times low enough to satisfy users but i wonder if i split my index by cateories that i have would i have better performance for queries ?
Ex : alldocsindex(1M) => allcat1index(120k) , allcat2index(70k), allcat3index(100k)...

2

What does your doc look like?
If you have a category field just filter on that.

3

Yes, i already filter by category. But the point that i wanted to ask reducing doc count on index makes any significant difference on performance. For instance i have a property on docs that is "Status" which tells me if the doc is "Active" or "Passive". Mainly i use "Active" docs. So if i split docs by "Active" and "Passive" and create them on two diffrent index does it make any significant difference on performance

4

I wouldn't think so, you'd need to test to be 100% sure.
But filters are super efficient so I'd stick with that.

5

This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.