Beefy Boxes and Bandwidth Generously Provided by pair Networks
Perl-Sensitive Sunglasses
 
PerlMonks  

Re: RDB updates: rebuild from scratch vs. incremental

by polettix (Vicar)
on Aug 30, 2005 at 15:22 UTC ( [id://487802]=note: print w/replies, xml ) Need Help??


in reply to RDB updates: rebuild from scratch vs. incremental

In other words, the values of these fields would not be meaningful across builds. Would this be a problem down the line?
I fear yes. Unless you're doing a simple store-and-peek system, if you want to build derived tables that refer to the original data you'll be losing the derived data at each step (or you'd be forced to rebuild that as well).

Of course, this is in addition to the considerations above, in particular the fact that you would interrupt service with the first approach. The whole point of the RDBMS should be that you can work on the data with the least interference on what the other users are doing.

Flavio
perl -ple'$_=reverse' <<<ti.xittelop@oivalf

Don't fool yourself.
  • Comment on Re: RDB updates: rebuild from scratch vs. incremental

Log In?
Username:
Password:

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

How do I use this?Last hourOther CB clients
Other Users?
Others lurking in the Monastery: (3)
As of 2025-07-14 08:23 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    No recent polls found

    Notices?
    erzuuliAnonymous Monks are no longer allowed to use Super Search, due to an excessive use of this resource by robots.