ColdFusion | Query timeout error questions

Question

Here is my code

<cfquery name="employeeData" datasource="xyz" cachedwithin="#CreateTimeSpan(0,0,60,0)#">
    SELECT employee, salary
    FROM employee
</cfquery>

<cfquery name="wellPaidEmployee" dbtype="query">
    SELECT employee, salary
    FROM employeeData WHERE salary > <cfqueryparam cfsqltype="cf_sql_integer" value="10000">
</cfquery>

Condition:
The first query EmployeeData gets timed out due to some issue and throws an error "query timed out"

Question:

1. On the next call, Will the query EmployeeData run or it will have query timed out error in the cache as we cached it using cachewithin?
2. What will happen with the wellPaidEmployee on first run and next run?

Answer 1

Only successful db requests are cached so the EmployeeData query will run on next pass.

The wellPaidEmployee query will run if employeeData does not error.

Answer 2

Too long for a comment.

Queries timing out, and caches expiring are two different things.

<cfquery name="employeeData" datasource="xyz" cachedwithin="#CreateTimeSpan(0,0,60,0)#">
SELECT employee, salary
FROM employee
</cfquery>

Will run when it is first hit. It will also save its data for 60 minutes. If that data is accessed again in 60 minutes, the cache timeout will reset back to zero. In theory, if this data is accessed every 60 minutes, it will never hit the database.

As for

<cfquery name="wellPaidEmployee" dbtype="query">
SELECT employee, salary
FROM employeeData WHERE salary > <cfqueryparam cfsqltype="cf_sql_integer" value="10000">
</cfquery>

It does not know, nor does it care if the underlying data came from a cache or not. It will just return the results.

If you are getting a "query timed out" error. That is a completely different problem. There is something wrong with how ColdFusion is connecting to the database OR there is a problem with the database itself.