Let me double check. Are each of those queries being run each time the page loads, or only when the function in which they live is called?
-----Original Message----- From: Mike Francisco [mailto:[EMAIL PROTECTED] Sent: Wednesday, April 16, 2008 1:34 PM To: CF-Talk Subject: Are cfqueries on a UDF effecient? Hello all. I am curious and I hope someone can give me a definitive answer. I have an app where I put all my cfqueries into several reusable functions, then I place those on into a single UDF file. Then, I cfinclude the entire udf file (library) on the pages where it uses some of the queries on the file. I realize that sometimes it might only use 2 or 3 query functions, of about 20 that is on the udf query library. My question is that, is this technique slowing the CF server down when it loads a page? Is CF processing any of the queries that are not being called out as a function on any given page? Thanks and I look forward for great advise from all gurus on the list. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:303590 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
