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
