Mitch Skinner wrote: > On Mon, 2006-01-23 at 20:41 -0500, Michael Bayer wrote: >> > the following minor patch makes >> > selectone() much faster for large >> > result sets: >> >> hmm does it really ? I am most accustomed to Oracle where getting >> just the first row back of a huge result set is not much different >> than just getting one > > Well, AFAICT selectone() gets more than just the first row back--it > fetches and instantiates the entire result set.
oh duh, youre right. Its tricky to select "just the first row" because in the case of eager loading, you have to load multiple rows to load the first "row". There are ways to trap that as well so I might want to look into that, but "limit" is a good place to start. > > oracle ROW_NUMBER stuff > Ill see if the current "rowid" functionality works for most cases, and I'll look into this to see how much of an alternative it is. ------------------------------------------------------- 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://sel.as-us.falkag.net/sel?cmd=lnk&kid=103432&bid=230486&dat=121642 _______________________________________________ Sqlalchemy-users mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/sqlalchemy-users
