Re: tempspace
Posted in 2000
Mike South wrote: > > if you arent using a RAID 5 type set up with parallel reads then you > will benefit from a gragmented TEMPspace...ie across several > drives...provided of course the tempspace is used as much as you say. I'm not sure I follow this entirely, but if you mean striping a temp dbspace is better for performance than multiple temp dbspaces, then I can't agree. For the simple reason that multiple temp dbspaces generate multiple read and write threads in parallel. Cheers, -- Mark. +----------------------------------------------------------+-----------+ | Mark D. Stock mailto:mdstock@mydas.freeserve.co.uk |//////// /| | http://www.informix.com http://www.informixhandbook.com |///// / //| | http://www.iiug.org +-----------------------------------+//// / ///| | |This email will self-destruct in |/// / ////| | |10 sec. If you received this email |// / /////| | |in error, sorry about the mess. |/ ////////| +----------------------+-----------------------------------+-----------+