Beefy Boxes and Bandwidth Generously Provided by pair Networks
good chemistry is complicated,
and a little bit messy -LW
 
PerlMonks  

Re: Re: Record edition management strategy needed

by MrCromeDome (Deacon)
on Sep 08, 2003 at 20:27 UTC ( [id://289854] : note . print w/replies, xml ) Need Help??


in reply to Re: Record edition management strategy needed
in thread Record edition management strategy needed

Actually, if some of those columns are part of a primary/foreign key or an index, updating those columns can make a huge difference. Whatever DBMS you're using will have to either partially or completely reconstruct those index structures to account for the update.

I strongly recommend updating only those fields that you need. Aside from being a potential timesaver, it's just cleaner IMHO.

Cheers!
MrCromeDome

  • Comment on Re: Re: Record edition management strategy needed