That's correct. Unless you NEED the whole dataset, it's always better to limit at the query level, rather than the output level.
-----Original Message----- From: Russ [mailto:[EMAIL PROTECTED] Sent: Monday, June 11, 2007 12:49 PM To: CF-Talk Subject: RE: Performance advantage - LIMIT VS. maxrows? I believe if you specify maxrows="10" it will pull down the whole resultset and then only grab the first 10 rows. Similar to doing <cfoutput query="queryName" maxrows="10"> Using Top/Limit is preferable. Russ > -----Original Message----- > From: Will Tomlinson [mailto:[EMAIL PROTECTED] > Sent: Monday, June 11, 2007 1:37 PM > To: CF-Talk > Subject: Performance advantage - LIMIT VS. maxrows? > > MX7 / MySQL 5. > > I need to query a large table of data, but only want to pull the top > 10 rows or so. > > Is there an advantage to using LIMIT 10 in the query, over <cfquery > maxrows="10">? > > Or vice versa? > > Thanks, > Will > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Create Web Applications With ColdFusion MX7 & Flex 2. Build powerful, scalable RIAs. Free Trial http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJS Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:280683 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
