On Mon, Mar 9, 2009 at 5:05 PM, Claude Schneegans wrote: > > >>because that is the only way to get a recordcount. > > A big price in efficiency to pay for something we use only sometimes. > Most of the time, we only need to know if there are records or not.
That is what maxrows is for. The query will still execute to completion on the database server, but CF will stop fetching results after it has reached its maximum. Jochem -- Jochem van Dieten http://jochem.vandieten.net/ ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:320291 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4