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
Expected behaviour for sort queries Dgraph discussion	16	2144	March 25, 2021
Does order in a DQL query matter? Dgraph	13	752	February 14, 2023
Inconsistent response of sort as a result of indexing of a predicate Dgraph	8	860	September 21, 2020
Returning sorted results by number of matches Dgraph kind:question	1	333	November 30, 2020
Pagination using "after" seems to ignore sorting Users	3	693	May 4, 2020

Sorting and counting issue

Related Topics