Beefy Boxes and Bandwidth Generously Provided by pair Networks
We don't bite newbies here... much
 
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

Log In?
Username:
Password:

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

How do I use this?Last hourOther CB clients
Other Users?
Others having a coffee break in the Monastery: (6)
As of 2024-03-28 09:55 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    No recent polls found