It's funny you should bring caching up, Dave. What do you make of this error message?
Retrieval of cached query failed The error occurred while processing an element with a general identifier of (CFQUERY), occupying document position (74:1) to (74:175) in the template file C:\WEBSITE\HTDOCS\SMARTER\QUERIES\QRY_SEARCHHANDL_ORIGINAL.CFM. Where the cached query at line 74 is: <cfquery name="VERITYSEARCHLISTINGS" datasource="#REQUEST.DSN#" username="#REQUEST.USER#" password="#REQUEST.PASS#" blockfactor="100" cachedwithin="#CreateTimeSpan(0,0,5,0)#"> SELECT ID FROM afulltable (nolock) <cfif comparenocase("#REQUEST.GetClientDataCity.City#","All Cities")> WHERE City = '#REQUEST.GetClientDataCity.City#' AND ( CONTAINS(fulltext,' #VARIABLES_SEARCHTERM# ')) <cfelse> WHERE CONTAINS(fulltext,' #VARIABLES_SEARCHTERM# ') </cfif> </cfquery> best, paul At 02:37 AM 12/8/02 -0500, you wrote: >Meanwhile, I've seen far too many CF developers neglect the very foundations >of adequate web application performance - caching, database optimization, >server tuning, and did I mention caching? ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm