Well I think the count() example is sort of outside of the scope of what was being described... The specific question (as I understood it) was whether a pair of queries could be faster for presenting a sub-set of records in a list page -- the count() query isn't part of the task of fetching and presenting those records, so it's sort of moot. And in that scenario, if you use the 2-query approach, you can use query1.recordcount to get the total number of records (and divide that to get the number of pages), so that eliminates the need to perform a separate count() query if you want to display total # of available records on the page.
> I agree with Isaac. The first query could even be: > <cfquery name="TotalCount"> > select count(id) as TheCount > </cfquery> s. isaac dealey 954.522.6080 new epoch : isn't it time for a change? add features without fixtures with the onTap open source framework http://www.fusiontap.com http://coldfusion.sys-con.com/author/4806Dealey.htm ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:217030 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=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
