Re: Informix LRU adjustment advice wanted

From: "Rob Gale" <rgale@[no_spam]iclretail.com> > >Oh wise gurus...your advice please... Sorry, they all seem to be out at the moment, you'll have to make do with me instead! :-) >Will increasing the number of LRU queues help ? What should I do about >CLEANERS? Probably. Try LRUS == CLEANERS. (i.e. 20 each) As a starting point. >Also, I am planning to go from Unbuffered to Buffered logging - any idea >how >much perfomrnace difference this will make ? Well, you won't find many fans here, because some (Art for one) will say that you're open to (a teeny-weeny little bit of) data loss. I'm a bit more broadminded -- and the performance jump should be quite stunning. You'll can also play with PHYSBUFF and LOGBUFF for even more performance. ______________________________________________________ Get Your Private, Free Email at http://www.hotmail.com