Re: Copying across databases

Posted in 2004

Andy Kent — Tue, 10 Aug 2004 14:45:47 +0100 — source: Usenet: comp.databases.informix

Having delved into this closer and now seen the client's message log, the problems seem to be: 1. Long checkpoints. Their disk space has all been configured on a single HP logical volume group; not something I usually feel comfortable with. Are these things inherently slow with writes? (I don't think (at least I hope not) there's a nasty RAID architecture lurking under there). 2. Lots of writes to the physical log, which I've been able to reproduce on my own box (9.40 on w2k). This happens even without logging and with the target table created as type RAW. Why? Andy