Re: Performance problem

Raymond Chow wrote: > > Help please!! I have two different machine. Risc6000 R40 and Risc6000 59H. > R40. IGB RAM, SSA DISKS, faster CPU > 59H, 324MB RAM, slower CPU. > > My day end run, seems that the 59H is faster than R40. Sounds ridiculous. > But it is true. > Any help in here? > Any reference on good Informix performance tuning book? > I have noticed that the cache writes is 72% while cache reads 91%. > Would fragmentation by round robin helps if the sql statement filters 4 > columns. According to the book, it is not recommended. > Regards Your cacheing rate for writes is very poor. At the risk of stating the obvious, you have far more physical memory on your "R40". So you can experiment with much higher values of BUFFERS than before. Off the top of my head, I might start with BUFFERS set to 50,000 (100MBytes) and see how that goes. Neil Truby Chase Manhattan Bournemouth, UK