Re: Raw I/O vs files
Posted in 1993
Topics: General Discussion
In article <2500@coyote.UUCP>, gainer@slowmo.almaden.ibm.com (P. Gainer) writes: |> |> Has anyone done much benchmarking to determine whether recent raw I/O |> implementations are *significantly* faster than file system implementations? 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 Database Administrator |UUCP : ...!uunet!uupsi2!aruba!curtl --------------------------------------------------------------------------