Re: Informix performance Issues

Tim, I've heeded Art's advice, ignoring the Fine Manual, training, yea even the Informix 50/60 defaults, and got a performance boost. The manuals also explain that the chunk write is cool because they are sorted writes, but hey what about the overhead? And on my old system which requires a real balancing act to keep running, any delay for writing the buffers seems to lock it up in an eternal (CKPT REQ) during someone's critical section. I've even gone to unbuffered logging. Just my .02 worth, Nick On Thu, 10 Jun 1999, Tim Schaefer wrote: > "Art S. Kagel" wrote: > > > > Fg Writes LRU Writes Chunk Writes > > > 0 0 27085 > > > > You show 100% chunk writes. No matter what the manual states chunk > > writes are death! You MUST detune the LRU_MIN/MAX_DIRTY from the 90/80 > > to a more reasonable 50/10. You do not need the 2/0 that a heavy > > transaction system needs but I'd bet your checkpoints are taking over > > a minute out of every 50 minutes when they could be taking 10-20 > > seconds instead. > > > <...> > > > > Art S. Kagel > > Art, > > Not only do the manuals state chunk writes are best, but the training > states this as well. Could you elaborate on why chunk writes are bad? > This is counter to not only the docs but the training. > > Thanks, > > Tim > -- > - > -- > --- Tim Schaefer > ---- tschaefe@mindspring.com > --- http://www.inxutil.com > -- > - >