My shared CF SERVER Environment, is usually down many times each day, well is it search-site-procedu
My shared CF SERVER Environment, is usually down many times each day, well is it search-site-procedure the problem?
well, can you guess what needs improvement?
500 The request has exceeded the allowable time limit Tag: CFQUERY
The request has exceeded the allowable time limit Tag: CFQUERY
<cfif URL.searchKeyword EQ 1>
<cfset searchKeyword=#form.searchKeyword#>
<cfparam name="Session.searchKeyword" default="polis">
<cfquery datasource="mysqlcf_" name="getData" >
<CFOUTPUT>
SELECT Products.*, Categories.* FROM Products INNER JOIN Categories ON Categories.Category_ID = Products.Category_ID WHERE Visibility=1 AND Category LIKE '%#searchKeyword#%' OR Product_ID LIKE '%#searchKeyword#%' OR Product_Name LIKE '%#searchKeyword#%' OR Product_Description LIKE '%#searchKeyword#%'
</CFOUTPUT>
</cfquery>
<cfelse>
<cfset searchKeyword=Session.searchKeyword>
<cfquery datasource="mysqlcf_" name="getData" >
<CFOUTPUT>
SELECT Products.*, Categories.* FROM Products INNER JOIN Categories ON Categories.Category_ID = Products.Category_ID WHERE Visibility=1 AND Category LIKE '%#searchKeyword#%' OR Product_Name LIKE '%#searchKeyword#%' OR Product_Description LIKE '%#searchKeyword#%'
</CFOUTPUT>
</cfquery>
</cfif>
<cfif getData.recordcount LE endrow>
<cfset endrow=getData.recordcount>
</cfif>
