Using Oracle /*+ append */ and ColdFusion
CFML, Oracle |
To increase the performance of an insert into an Oracle database one can use the /*+ append */ hint while doing an insert. Actually, by using the append hint, you ensure that Oracle always grabs "fresh" data blocks by raising the high-water-mark for the table. The code for this would look like:
insert /*+ APPEND */ into ..........
So, it is obvious that one would use the same within a <cfquery> tag to also increase the performance of ones application. But today I learned the hard way (actually almost "wasted" 2 hours to find this out) that when using the ...