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 robust enterprise, web RIAs. Upgrade & integrate Adobe Coldfusion MX7 with Flex 2 http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJP Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:280680 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
