Re: MODE ANSI DATABASES

On 20 Nov 96 at 13:29, , @compuserve.com wrote: > Does anybody know where I might find some kind of list to detail the > differences between standard transaction logged databases and mode > ANSI databases. With MODE ANSI, you have unbuffered logging and you are always in a transaction. You COMMIT or ROLLBACK, and you're automatically put into a new transaction. With standard logging, you have to explicitly say BEGIN WORK to open a transaction. Unbuffered logging means that the log buffer gets flushed to disk immediately on COMMIT or ROLLBACK. Buffered logging means that only full log buffers get flushed to disk. Checkpoints will also flush log buffers. HTH. -- Ciao, Billy I'd be in favour of apathy, but I just can't get fired up about it...