Sorting and counting issue

MichelDiz · August 31, 2018, 11:03pm

I believe that this problem has already been clarified. To circumvent the limitation simply use paging greater than 1000.

e.g:

 A (func: has(price), orderdesc: <price>, first: 10000 ){

Quoting below:

Well folks, it’s not a bug. This is a limitation by default.

// Sort and paginate directly as it’d be expensive to iterate over the index which
// might have millions of keys just for retrieving some values.

// Only retrieve up to 1000 results by default.

“if no “first” or “last” etc. argument is specified, it would default to 1000.” mrjn.

github.com

dgraph-io/dgraph/blob/06ea4c545bc3cf0ed730327557dbff96406e75f8/query/query.go#L2146


      
          	for _, it := range sg.Params.NeedsVar {
          		// TODO(pawan) - Return error if user uses var order with predicates.
          		if len(sg.Params.Order) > 0 && it.Name == sg.Params.Order[0].Attr &&
          			(it.Typ == gql.VALUE_VAR) {
          			// If the Order name is same as var name and it's a value variable, we sort using that variable.
          			return sg.sortAndPaginateUsingVar(ctx)
          		}
          	}
          
          	if sg.Params.Count == 0 {
          		// Only retrieve up to 1000 results by default.
          		sg.Params.Count = 1000
          	}
          
          	x.AssertTrue(len(sg.Params.Order) > 0)
          
          	sort := &intern.SortMessage{
          		Order:     sg.Params.Order,
          		UidMatrix: sg.uidMatrix,
          		Offset:    int32(sg.Params.Offset),
          		Count:     int32(sg.Params.Count),

Thank you for reporting this.

Cheers.

Topic		Replies	Views
Sorting doesn't work on queries with cascade Dgraph kind:bug	9	1366	June 20, 2024
Sorting by count Dgraph	6	2791	September 9, 2023
Expected behaviour for sort queries Dgraph discussion	16	2378	March 25, 2021
Does order in a DQL query matter? Dgraph	13	844	February 14, 2023
Adding sorting to DQL query reduces the number of results Dgraph kind:bug , dql	8	1363	September 21, 2021

Sorting and counting issue

Related Topics