On Thu, 10 Mar 2005 09:50:37 -0500, Douglas Knudsen <[EMAIL PROTECTED]> wrote: > ok, maybe I'm on some bad crack today, but I recall that the maxrows > attribute of cfquery works AFTER the resultset is returned to CF from > the DB. Is this the case for all RDBMs? I'm noticing that this is > not the case with CFMX and Oracle. Maybe this behaviour changed? >
Yes, it first pulls back all records the query itself specifies, and then does the equivalent of a "TOP" to get the number of rows on the ColdFusion side. We use Oracle (8i, 9i, and 10g) and all 3 versions in MX first pull back all records requested. Personally I would never suggest using maxrows for this reason. In Oracle a simple inner view (because there is no TOP) will handle your request much more efficiently. Regards, Dave. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:198193 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
