Note: This blog post is from 2010. Some content may be outdated--though not necessarily. Same with links and subsequent comments from myself or others. Corrections are welcome, in the comments. And I may revise the content as necessary.

Did you know there is now a setting in the DSN page of the CF Admin (for most of the Adobe-provided DB drivers) which allows you to set a maximum timeout for queries against that DSN?

It's a new feature enabled for the DataDirect drivers, as updated in CF 9. (You will not see it if you use an "other" datasource type, such as when using a downloaded JDBC driver that you implement on CF.)

The caveat? This timeout is ONLY settable there in the DSN definition, not in CFQUERY (or CFSTOREDPROC) itself, which is a shame. The existing TIMEOUT attribute for those (CF10 added it for CFSTOREDPROC) is not the same and generally does not work. Still, the value of this even at the DSN level is too important to ignore for some challenges. More on that (and some other thoughts) in a moment.

[....Continue Reading....]

Note: This blog post is from 2010. Some content may be outdated--though not necessarily. Same with links and subsequent comments from myself or others. Corrections are welcome, in the comments. And I may revise the content as necessary.

• I was a roundtable participant in last week's RiaPodcast episode 2.9 (you can listen there)
• I was co-host on the CFHour() podcast, show #60 a couple of weeks ago (you can listen there)
• I was invited (along with Michael Smith) to be interviewed by Judith Dinowitz of FusionAuthority on the recently announced fact that this would be the last year of CFUnited, which I've spoken at each year. (You can read the interview at the FA link offered.)
• It was announced last week that I'll be hosting a BOF (birds of a feather) session at the CFUnited conference. The session will be "CF911: Server Troubleshooting". More details at the page above.
• It was announced last week as well that I will be giving another session at CFUnited, this one being the Sponsor talk for Intergral (makers of FusionReactor, with whom I partner a lot). The topic is "Continuously Improve CF Code Quality, Server Availability & Application Stability". More details here.
• Finally, more details about my Day 2 keynote at the conference were also announced a couple of weeks ago. The topic will be, "CFCommunity: You're Never Alone". More details at the link offered.