How to efficiently sort a list ?
- I’ve a thing
carwith a list field of
- The thing
colorhas two fields
- I need to display in a RG the colors (of that car) sorted by id.
But I’m surprised it’s not possible to do:
search for car: each colors SORTED by id.
The only option seems to do
search for colors: where car = car; SORTED by id, but it’s a nightmare of slowness if I have many colors.
Do you have a more efficient solution to use the first option?