It would seem that TOP is more efficient because you're dropping the extra rows on the sql side instead of the cf side, thereby saving yourself some resources on the recordset transfer.
</rob> -----Original Message----- From: Tyler Silcox [mailto:[EMAIL PROTECTED]] Sent: Thursday, May 02, 2002 6:32 PM To: CF-Talk Subject: SELECT TOP n vs MaxRows... A quickie: Is there any benefit to using SELECT TOP n vs using the MaxRows attribute in cfquery? Tyler Silcox email | [EMAIL PROTECTED] ______________________________________________________________________ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
