03 April 2007

I have not yet begun to fight!

So sayeth John Paul Jones (not this one), so sayeth I.

I've been taking steps to make sure my developers know of the many benefits of using bind variables, and the punishments for not using bind variables. This is paying off in the newer code coming out, but it will take a while to re-write some of the older applications.

Today, while tracing another query, I saw that one of the back office applications that dealt with batch rating was using a query without bind variables. In the timeframe of 1 hour this morning, the same query with a different literal value was called over 21,000 times. The same app was bulk issuing two other queries using literals as well. Let's just say that it was made certain that this needed to be changed.

No comments:

Post a Comment