Yes maxrows fetches all from the database. The best option is to use top n or the equivalent to your database in the query.
-----Original Message----- From: Leigh [mailto:[email protected]] Sent: Tuesday, 19 January 2010 8:28 PM To: cf-talk Subject: RE: More Efficient (Faster) Method > For the record, putting maxrows=1 in a cfquery still asks > the database to retrieve all the rows-- the drivers just > stop fetching after the first row. I agree the safer bet is to limit at the database level. But I thought the maxrows behavior was determined by the driver? ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:329779 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
