Re: Optimizing write performance

Stefan Weideneder (stefan@weideneder.de) wrote: : Stephen Walmsley wrote: : > : > Further to the recent discussion about the relative merits of mirroring, : > RAID etc., what if I had a database which is updated in bulk and queried <snip> : Hi, : first I guess it's a good idea to spread the huge table across : several disks and perform the i/o in parallel mode. It's also He's on 4.1. Any parallelism will have to be done programmatically, because the engine doesn't support it. -- --------------------------------------------------------------------------- Joe Lumbley(jlumbley@netcom.com) author of: "INFORMIX DBA Survival Guide" Slaving away on "INFORMIX DBA Survival Guide, The SQL", available late 1998 from Prentice Hall/Informix Press. ---------------------------------------------------------------------------