Ben Forta

AdobeStock_455007340

Timing Query Execution

Most developers know they can refer to query.RecordCount to obtain the number of records retrieved by a query, many even know that they can access query.CurrentRow to access the current row in an output loop and query.ColumnList for a list of retrieved columns. But here’s one that many developers don’t know – refer to CFQUERY.ExecutionTime to obtain the amount of time a query took to execute (just as it appears at the bottom of the page in debug mode). (Applies to: ColdFusion 4.5 (or later))

Leave a Reply