Subject | Re: [ib-support] Forced writes on 1.02 |
---|---|
Author | Helen Borrie |
Post date | 2003-04-14T11:35:51Z |
At 08:23 AM 14/04/2003 -0300, you wrote:
Still, I think it is a valid question, since the matter of forced writes
doesn't relate to transactions. In fact, the updating of the generator is
a database operation (it updates a page in the database). One could expect
that the engine might make an exception in the case of this page, and not
delta the old recversion or cache the new. I don't know whether it
does. I hope Ann is looking at this thread.
heLen
>Hi,Daniel,
>
>At April 14, 2003, 07:26, Roland Turcan wrote:
>
> > If I have set Forced Writes to ON, is new generator value writed to
> > database immediately?
>
>Force Writes relates to writing to the hard-disk, not to the database.
>And, it doesn't make any difference, because Generators work outside
>of the transaction, and they are written to the database immediately.
Still, I think it is a valid question, since the matter of forced writes
doesn't relate to transactions. In fact, the updating of the generator is
a database operation (it updates a page in the database). One could expect
that the engine might make an exception in the case of this page, and not
delta the old recversion or cache the new. I don't know whether it
does. I hope Ann is looking at this thread.
heLen