Not in this scenario. You have to select ALL records to extract or output the ones you want.
So my original example was 1. query all the required records 2. output the ones you want The one your saying is better 1. query all the required records 2. query a subset of those records 3. output the records. Thus an extra step to produce the same output. Of course querying the database a second time is going to take up more memory for the 2nd query and take longer to process. If you don't believe me, just try it for yourself. Russ -----Original Message----- From: Claude Schneegans [mailto:[EMAIL PROTECTED] Sent: 31 August 2005 17:47 To: CF-Talk Subject: Re: Paging through records >>I already pointed out that this other method does exactly the same thing, but also adding an additional query. My point is that adding an additional query does not imply that the overall result is less efficient, on the contrary. One may have two small queries that are much faster than one big. -- _______________________________________ REUSE CODE! Use custom tags; See http://www.contentbox.com/claude/customtags/tagstore.cfm (Please send any spam to this address: [EMAIL PROTECTED]) Thanks. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:217015 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
