Hello, On Freitag, 28. M�rz 2003 10:16, Dmitri Lyssenko wrote: > > It appeared from the test that if the log writer is disabled (that I > believed give me the best performance) the database starts flushing the data > cache very often...probably on each commit. > This guess is originated from the look at the "vmstat" output > (however I might be wrong). As result having these 2 options together (SET > LOG WRITER OFF and USE_O_DIRECT YES) gave me the worst performance. > Is it right that the frequencity of the savepoints depends on the state of > the log writer (disabled/enabled)...and therefore O_DIRECT should not be used with the log switched off? > I think any REAL database should flush the buffers on each and every commit. That's what commit is here for.
Peter Willadt _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
