Re: Logical log write volumes

> The calculation should be something like: > > 16 bytes + rowsize for each row inserted > 16 bytes + indexsize for each row/for each index on the table > (these numbers might be +/-4 in either direction) > > This is for an insert. Updates and deletes are different. If the minimum unit of work is a page, won't it be one page per insert with unbuffered? And if you do ten inserts to the same page, won't that mean only one *disk* i/o with buffered (as long as all ten inserts are between buffer flushes)? akent@cix.compulink.co.uk (Andy Kent) ------------------------------------------------ Freelance Informix Database Specialist, Redland, Bristol, England