How to sort scroll?

[msj121]

It should be possible to sort results by a payload qualifier, even if this is limited to scroll.... If I scroll all restaurants that serve pizza, why can't I sort by when it was established, or the price etc.... Is this part of the future roadmap, because I readily need this. I assume others do too... Is there a current work around?

[timvisee]

If I scroll all restaurants that serve pizza, why can't I sort by when it was established, or the price etc....

This is a limitation because of how scroll is implemented. Scroll goes over all point IDs in order, allowing you to fetch all points from a collection.

It currently does not support a different sorting approach as it would require Qdrant to sort all point IDs beforehand. While this would work fine if you'd have 100 points, this doesn't scale well to billions of points.

In your case, would it be possible to fetch all results and sort in your client instead?

Also, could you please elaborate further on why you'd need this? It sounds like a type of query where a classic relational database would work better.