Groupby on multiple fields using DQL

@MichelDiz Sure, I will open up an issue maybe on the weekend.

Can you please comment on this part?

Let’s say we have 10k nodes for UserStatus type. We have to fetch them all to apply the aggregation at application level. How will it impact the overall performance of dgraph if the number of nodes grow to 100k. Would it still be feasible to fetch them at once?
OR
Would it be recommended to fetch the 100k nodes in batch of 10k. Which will require 10 queries before we do the aggregation.

I don’t want to rely on the application logic assuming it’s fine querying large number of nodes where I’m not sure about the limit. So, I’m just confirming some metrics to foresee bad situations as the data grows for that query.

2 Likes