Charlie Griefer wrote: > I'll have to double check this... but I believe recent versions of CF > (as of MX perhaps?) do -not- pull down the whole resultset. > > If this is the case (and I stress -if-...), then I'd say that using > maxrows would be preferrable as it'd make your applications more > portable across different databases.
Even then limit is still preferable performance wise. It gives the database the opportunity to better optimize the query and choose an execution plan that may have a higher cost at a large number of records, but a lower cost at a low number of records. Jochem ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| ColdFusion MX7 by Adobe® Dyncamically transform webcontent into Adobe PDF with new ColdFusion MX7. Free Trial. http://www.adobe.com/products/coldfusion?sdid=RVJV Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:280691 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
