Re: changing size of logs

Neil Truby wrote: > > Don't you think 1 megabyte logs is taking this a bit too far, though? In general I would agree. But it depends on the transaction activity and how quickly logs fill. It might take a day to fill a 5Mb log, so 1Mb could take an hour or so. The other consideration is log buffer size and logging mode. If log buffers are very large and all databases use buffered logging, then this could be the reason logs fill slowly. 2c. 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"!|/ ////////| +----------------------+-----------------------------------+-----------+