Re: Performance problem

Posted in 1997

Manuel Abranches Pintor — 29 Mar 1997 23:06:57 GMT — source: Informix-list mailing list archive (1991-1998)

Raymond Chow <raychow@pc.jaring.my> escreveu no artigo <01bc3a2c$94c45c80$d3db8ea1@Mimos.Jaring>... <snip> > 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 certainly recommend the Elizabeth Suto's book: "Informix Performance Tunning", 2nd. edition. > 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 > Manuel Pintor >