Hot Topic – SELECT FOR UPDATE/WHERE CURRENT OF

“Holy Cow, two blog posts in one day!” – Harry Caray

Ben Thompson over at Informed Mix currently wrote about using “select for update/where current of” syntax and in the mother of all coincidences one of the developers that writes code that hits my Informix engines came over to tell me about the evolution of performance improvements he went through to speed up a bulk data delete application. Here is his story, from static SQL all the way to prepared statements using the “select for update/where current of” syntax.

First, the formalities. This particular developer is writing an application that wil…

Auteur : noreply@blogger.com (Andrew Ford)

No comments yet.

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.