> Hmmm ... if you were willing to dedicate a half meg or meg of shared > memory for WAL buffers, that's doable.
Yup, configuring Informix to three 2 Mb buffers (LOGBUF 2048) here. > However, this would only be a win if you had few and large transactions. > Any COMMIT will force a write of whatever we have so far, so the idea of > writing hundreds of K per WAL write can only work if it's hundreds of K > between commit records. Is that a common scenario? I doubt it. It should help most for data loading, or mass updating, yes. Andreas ---------------------------(end of broadcast)--------------------------- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]