ws-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Apache Wiki <wikidi...@apache.org>
Subject [Ws Wiki] Update of "Tuscany/TuscanyJava/DAS Java Overview/RDBDAS Java User Guide/Partial Update" by KevinWilliams
Date Mon, 02 Oct 2006 18:26:09 GMT
Dear Wiki user,

You have subscribed to a wiki page or wiki category on "Ws Wiki" for change notification.

The following page has been changed by KevinWilliams:
http://wiki.apache.org/ws/Tuscany/TuscanyJava/DAS_Java_Overview/RDBDAS_Java_User_Guide/Partial_Update

------------------------------------------------------------------------------
     UPDATE CUSTOMER SET FIRSTNAME = ?, SET LASTNAME = ?, SET ADDRESS = ?, SET PHONE = ?,
SET AGE = ?, SET SHOESIZE = ? WHERE ID = ?
  }}}
  
+ There are a couple of very good reasons for using a partial update approach.  For one, a
performance boost can be reaized by applications writing to very wide tables.  For example,
this author has seen customer tables with over  100 columns.  I can be a waste of resources
to update 100 columns when only one was modified.  Another reason is that some databases also
employ [http://en.wikipedia.org/wiki/Database_trigger triggers] on specific columns in a table.
+ 

---------------------------------------------------------------------
To unsubscribe, e-mail: general-unsubscribe@ws.apache.org
For additional commands, e-mail: general-help@ws.apache.org


Mime
View raw message