The IIF function is slower, and less readable than using conditionals

Using SELECT * often returns more columns than necessary.

Use the equals operator in the CFSET tag instead for a speed and readibiliity increase.

StructFind is slower and less readable than dot or bracket notation.

Variables that resolve to true/false,yes/no, or 1/0 can be treated as booleans. Use cfif var, or cfif NOT var instead of cfif var IS true.

IncrementValue is very slow use the addition operator inside of cfset instead.

Set the allow overwrite argument to true for a speed increase

Use the Len function instead of IS ""