Beefy Boxes and Bandwidth Generously Provided by pair Networks
laziness, impatience, and hubris
 
PerlMonks  

Re: Re: Record edition management strategy needed

by MrCromeDome (Deacon)
on Sep 08, 2003 at 20:27 UTC ( #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

Log In?
Username:
Password:

What's my password?
Create A New User
Node Status?
node history
Node Type: note [id://289854]
help
Chatterbox?
and the web crawler heard nothing...

How do I use this? | Other CB clients
Other Users?
Others perusing the Monastery: (3)
As of 2021-04-17 02:57 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    No recent polls found

    Notices?