in reply to Re^2: RDB updates: rebuild from scratch vs. incremental
in thread RDB updates: rebuild from scratch vs. incremental

I agree :) It would also depend on the chosen DBMS on how much time the tables would be inaccessable to the users. In your case, it is probably less than a second. On low utilized servers, this is probably more than acceptable.. in other scenerios, the loss of a half second could amount to be thousands of dollars (trading systems for example).

Definitely, the possible solutions will vary :)

Jason L. Froebe

Team Sybase member

No one has seen what you have seen, and until that happens, we're all going to think that you're nuts. - Jack O'Neil, Stargate SG-1

  • Comment on Re^3: RDB updates: rebuild from scratch vs. incremental