Re: Importance of L.Log Buffer When database has No Buff. Mode

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 ? You are still using the buffers, you are just flushing them after each transaction. The smaller they are, the more often they will flush. It really depends on the size of your transaction data. For unbuffered logging you might even consider making the buffers larger, because you know they will flush at the end of the transaction anyway. You could then minimise the flushes per transaction. > I have 200 GB database which is unbuffered and > Logical log buffer size is 16 K The buffer or log size has nothing to do with your database size. It depends on your transaction size, the number of transactions and the performance you are looking for. Cheers, -- Mark. +----------------------------------------------------------+-----------+ |Mark D. Stock - Informix SA http://www.informix.com |//////// /| |mailto:mdstock@informix.com http://www.informix.com/idn |///// / //| |http://www.iiug.org +-----------------------------------+//// / ///| | Tel: +27 11 807 0313 |If it's slow, the users complain. |/// / ////| | Fax: +27 838250 2325 |If it's fast, the users keep quiet.|// / /////| |Cell: +27 83 250 2325 |Therefore, "No news: travels fast"!|/ ////////| +----------------------+-----------------------------------+-----------+