On Dec 9, 2005, at 8:25 PM, Robert Leftwich wrote:
What scope is there for changing this? One possibility is to add DESC to the oid as well, which would at least let the optimizer select a (foo, oid) index. Can the order by OID be removed completely and the sort for parent object order moved into python?
removed completely ? you mean theres no default sort order unless specified ? Its very convenient that you get your objects back in "insert-order" by default. If we leave that in by default, there just needs to be more logic to turn on and off the parent sort order based on other arguments so it doesnt get in the way of an explicit order_by.
though I guess the argument to not have it in by default is, when an app wants to get the objects back as fast as possible and doesnt need ordering. ill have to think about this.
------------------------------------------------------- This SF.net email is sponsored by: Splunk Inc. Do you grep through log files for problems? Stop! Download the new AJAX search engine that makes searching your log files as easy as surfing the web. DOWNLOAD SPLUNK! http://ads.osdn.com/?ad_id=7637&alloc_id=16865&op=click _______________________________________________ Sqlalchemy-users mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/sqlalchemy-users
