Re: When does bufwaits get incremented ?

Posted in 1997

Chris Lo — Wed, 27 Aug 1997 10:26:13 -0700 — source: Informix-list mailing list archive (1991-1998)

> I talked to the instructor at Informix UK > when I went on the Online 7 performance Tuning course. He contacted > the USA but still could not find out EXACTLY what bufwaits meant. > > He did say that if bufwaits was too high then increasing the number of > buffers would help (apparently this came from "the programmers in the > USA who have access to the source.."). > I thought you may be able to reduce them by lowering RA_* parameters, and also I think you can set RA_THRESHOLD close to RA_PAGES (e.g., 6 and 8 respectively). Chris