What is the best way to handle updating multiple columns

advertisements

If I have a profile form with 20 fields a user can update on a page. It seems like it would be a waste to run an update statement that would update every single column if the user only changed two fields.

I was wondering what would be the best way to handle this for the best performance.

Since I only have 20 fields its not really an issue but I am just wondering for future development of where maybe it could be more.

What does everyone else do, do you just update every column for that row?

Tools like Entity Framework (or other ORM tools) will handle this for you, for "free".

They track what has changed in your objects, and they will issue a tailor-made UPDATE statement that will only update those columns that have actually changed.

You need not worry about any of those details anymore. All taken care of for you. Try it!

Resources:

Related Articles

What is the best way to handle sending many emails in Rails?

I know about persisting the email into the db and then letting some periodical job handle the actual sending. I know that ar_mailer gem does this. Are there any other approaches? Are there better alternatives? Simply, What is the best way to handle s

What is the best way to handle an ExecutionException?

I have a method that performs some task with a timeout. I use the ExecutorServer.submit() to get a Future object, and then I call future.get() with a timeout. This is working fine, but my question is the best way to handle checked exceptions that can

What is the best way to handle delayed events in Java?

I am trying to make a simple game in android studio, and I need to be able to delay certain events. I started out by doing some googling and found that Timer with TimerTask seemed to be a pretty good option. However, if my activity calls onPause ther

What is the best way to handle Net :: HTTP exceptions?

What's the best way to rescue exceptions from Net::HTTP? Exceptions thrown are described in Ruby's socket.c, like Errno::ETIMEDOUT, Errno::ECONNRESET, and Errno::ECONNREFUSED. The base class to all of these is SystemCallError, but it feels weird to w