Optimization of complex filters

+1 , I am too interested in this - as recently, one of the user in slack “Bin Du” asked and shared his problem in facing performance issue with multiple condition in filter.

My opinion is the way badger is designed, it does not have multi column index thing so performance is going to get hit with multiple filter condition.

Here, one need to design schema in much better way to not have multiple filter and I believe that will be more like creating multiple data by setting more predicate and creating relation.

Key-Value database are not designed for relation thing, we need to set the relation from the query output. That’s one thing I have learned using key-value database.

Waiting for dgraph team opinion