>Building the loop in or out of the CFQUERY tag makes no difference in >performance.
My experience is that performance can be impacted slightly based on number of users, number of terms, and complexity of the query as a result of the parameters to be evaluated. We have found better overall performance by performing any looping or evaluating regular expressions and passing the overall results into the cfquery and resulting SQL statement ahead of time over determining it a sql time. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:334658 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm