Translating with DrWatson… this can take a few seconds the first time.
This is a genuine, complex translation. DrWatson protects commands, error codes, and log output while naturally translating the surrounding text. It’s translated once and saved.
Madison Pruet — — source: Informix-list mailing list archive (1991-1998)
Even with unbuffered logging, you still use the log buffer. It's only with
the commit that you write the buffer to the physical log file.
A lot of this has to do with the size of your rows, the number of rows updated
per transaction, etc...
It really doesn't hurt to have the log buffer size over-configured because we
only write out how much space in the log buffer is actually used.
Gokhan TERCAN wrote:
> Hi,
>
> Does anybody have any idea
> what the importance of logical log buffers =
>
> when the database is in unbuffered mode ?
> What is the recommended size for the buffers in
> this situation ?
>
> I have 200 GB database which is unbuffered and
> Logical log buffer size is 16 K
>
> Thanks,
> Gokhan
>
> ____________________________________________________________________
> Get free e-mail and a permanent address at http://www.amexmail.com/?A=3D1=
We use strictly necessary cookies to make this site work. With your
consent we’d also use optional cookies for analytics and marketing. You can accept all,
reject all, or choose. Read our Cookie Policy.