Re: Checkpoint Vs Savepoints

From: Daniel Guntermann <guntermann_at_earthlink.net>
Date: Wed, 10 Sep 2003 01:14:38 GMT
Message-ID: <2Wu7b.5142$PE6.1393@newsread3.news.pas.earthlink.net>

Yes. There is a difference.

Checkpoints are a feature where buffers are flushed and updates are guaranteed to be written to disk, and for some implementations, logged. Checkpointing is usually intricately involved with recovery features of a DBMS. A savepoint is a nested transaction concept which allows developers to have control on how much of a transaction is rolled back on error or failure. It gives more flexibility than an all-or-nothing transaction.

Dan

<tmalik_at_cs.jhu.edu> wrote in message news:3F5CA6C0.4090000_at_cs.jhu.edu...
> Is there any difference between the terms checkpoint and savepoint?
>
> Thanks,
> Tanu
>
Received on Tue Sep 09 2003 - 20:14:38 CDT