What is this approach to database updating called? -
say have set of objects in database: {a, b, c, d}
now, business logic has generated new list {a, b, e, f} , needs update old one:
two options nowadays themselves:
1)
remove entire list {a, b, c, d}
insert entire list {a, b, e, f}
2)
calculate items no longer needed: {c, d}
calculate items need added: {e, f}
remove {c, d}
insert {e, f}
now, naturally 1 of these approaches puts more load on db, , other puts more load on client.
my question is, these 2 approaches called? (read: can refer them in email , have other person understand and/or google , sensible, clarifying explanations?)
thanks!
database
No comments:
Post a Comment