Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

Do you know what is fater?

1 view
Skip to first unread message

noam gariani

unread,
Nov 25, 2009, 5:19:38 PM11/25/09
to

To do update for a record , or insert a record to a db?

Ed Prochak

unread,
Nov 27, 2009, 10:46:39 AM11/27/09
to
On Nov 25, 5:19 pm, noam gariani <noamgari...@gmail.com> wrote:
> To do update for a record , or insert a record to a db?

Depends.

Why do you care?

test

unread,
Dec 2, 2009, 4:57:55 PM12/2/09
to
Ed Prochak schrieb:

As I know in many cases an Insert can be done faster, because the DB
does not have take care of concurrency, to lock the row, keep the before
image for rollback and find the rows to update .... unlock ....after the
commit ... so there are many easy points the DB-Engine can be optimized
in performance doing an insert, but this does not say inserts are always
faster than updates and does never mean do an delete+insert instead of
updates.


Some Databases do any update as an kind of insert operation.
Like find the block -- change it in memory -- insert changed block to
datafile and mark old block as deleted. In that databases inserts and
updates are quite equal.

Frank van Bortel

unread,
Dec 10, 2009, 2:29:23 PM12/10/09
to
noam gariani wrote:
> To do update for a record , or insert a record to a db?
Mauve.

It's been green for a while, but now it's back to mauve.
If you don't believe me, query CDO* ng's for mauve.
--

Regards,
Frank van Bortel

0 new messages