Re: [sqlalchemy] similar to OrderingList but order in code instead of via sql?

2016-10-27 Thread Paul Winkler
6/2016 05:50 PM, Paul Winkler wrote: > > So I currently have this: > > > > thingies = relationship( > > "Thingy", > > order_by="Thingy.sort_order", > > collection_class=ordering_

[sqlalchemy] similar to OrderingList but order in code instead of via sql?

2016-10-26 Thread Paul Winkler
Hi all, I've been happily using OrderingList as a collection_class for some time. Recently discovered a slow query due to multiple JOINs where the order_by on the relationship ends up causing a table scan because the field in question is not indexed. One solution of course would be to add an