Monthly Archives: November 2014
Insert Performance analysis part 2
I promised I would have more today. Here is the raw data from my analysis. As you can see as rejection (dup_val_on_index) increased, the execution time for select + insert decreased and execution time increased for insert with exception. This … Continue reading
Posted in Database Stuff
Leave a comment
Insert performance on a unique constraint.
In the past, I have read about the performance of exception handlers and all that is said is, There is performance overhead. Okay, the generic answer of “performance overhead” tells us nothing. One of the great pleasures of what I … Continue reading