CFQUERYPARAM and Oracle Databases
Justin Fidler, Chief Technology Officer for Bantu, Inc., finds that one of the most important new features added in ColdFusion Server 4.5.1 is the CFQUERYPARAM tag, which enables the use of bind variables in a query. Bantu.com makes extensive use of the Oracle 8.1.6 database; using CFQUERYPARAM results in "a performance improvement of between 100 and 1000 percent, depending on the page." Here?s how CFQUERYPARAM works, related to Oracle.
CFQUERYPARAM and Oracle Databases