I have a MySQL DB with 20 million records. I need to search through it to find certain records.
But I don't want the query running so long that it brings down the DB server
Long running queries have done this before.
Is it possible to write code that says if this query is taking longer than 20 seconds then stop processing and output a message
Like "please try your query again later"
<cfquery name="foo" datasource="#application.dsn#" timeout="30">
Try the search later
There has been an error.. information below..
<cfdump var="#cfcatch#" />
Just an example.
^ _ ^
Thank you. Works great!
Thank you for marking my answer correct. I do appreciate it.
^ _ ^