> Can someone tell me how CF determines whether a query > is the same as a previously cached query?
CF compares the SQL statement and the CFQUERY attributes, except for the caching attribute itself. If they're all the same, and the cached query hasn't timed out, CF will use the cached query. Note that CFQUERYPARAM prevents the use of query caching. > Does it require an exact match on both the queryName > and the SQL (including whitespace)? This used to be the case; it may still be true, but I'm not sure. I've always worked under the assumption that it does, and made sure the whitespace and formatting are identical in all cases. > Is this matching criteria DB independent? No, it's not. > Is this version dependent (MX, 5, 4.5)? No, with the possible exception of the whitespace issue. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 ______________________________________________________________________ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
