Re: Informix Performance Tuning

In article <26rm39$3q8@news.delphi.com>, mbaime@news.delphi.com (MBAIME@DELPHI.COM) writes: |> Unlike the old engine which just used the UNIX file system (with all the |> negatives which pertain) the Informix online engine uses raw disk I/O. |> Much faster, much smarter, much better. Of course it will use the UNIX |> file system if you prefer less bang for your buck. Might be a reason you'd |> want to but I couldn't say why. About a year ago I did some benchmarking with Informix-ONLINE 5.0 on an HP9000/730 to determine if it was worth using raw I/O. To my amazement, cooked files outperformed raw I/O by about 10%. At this point I called Informix tech support, and was informed that on some hardware platforms, the UNIX file system could outperform raw I/O, and that HP was one such platform. In a development environment, I would not hesitate to use cooked files. However, if mission critical data is involved, I would always choose raw I/O. Using cooked files can result in data inconsistency after recovery. See the Online Administrator's Guide for a detailed explanation. (page 1-38) -- -------------------------------------------------------------------------- Curt Leaist |Internet: curtl@zed.com Project Zed |UUCP : ...!uunet!uupsi2!aruba!curtl --------------------------------------------------------------------------