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 hint Append like above one would also need to issue a “commit;” after this code, so that Oracle writes the data into the database finally.
This leaves us now with two options:
1. Use an additional <cfquery> with a commit (but not sure if this would really work….)
2. or then simply leave the append hint away from your code.
