Re: long checkpoints on informix

Posted in 2007

Sakura.ggxx@gmail.com — Thu, 19 Jul 2007 10:00:06 -0700 — source: Usenet: comp.databases.informix

On 18 jul, 16:48, "Art S. Kagel" <art.ka...@gmail.com> wrote: > On Jul 17, 11:44 am, Sakura.g...@gmail.com wrote: > <SNIP>> SunOS sun4u sparc SUNW,Sun-Fire-V240 > > Memory size: 4096 Megabytes > > RAID5 > > ^^^^^^^^^ > > But more seriously, are your chunks all RAW disk? Using COOKED files > will seriously degrade server performance by as much as 40% and at > least 25% over RAW disk unless you are using DIRECT IO which is first > supported in IDS version 10.10xc4 IB. (Even with DIRECT IO there's a > performance penalty of about 5%, but that's at least livable if the > convenience of COOKED files is desirable.) > > Art S. Kagel Well i have my chunks all RAW disk , btw i was reading about RAID5 and is a big problem i will see what to do with that, i have a question what type of ARRAY do you recommend? Also you are talking about "DIRECT IO" i was looking for information about it but i don t found specify information, can you help me with this?