Re: High lngspins - IDS 9.30 UC2

Posted in 2003

Mark D. Stock — Mon, 20 Oct 2003 18:38:54 +0100 — source: Usenet: comp.databases.informix

Art S. Kagel wrote: >>Mark D. Stock wrote: >> >>>I would like to see at least three on any system, especially one making heavy >>>use of temp tables. Preferably on different disks. Although that may be >>>difficult with your striping. > > That requires further elucidation, Mark. Please!?! Really? If I'm going to bother to fragment, then I like to do it with at least 3 fragments. I like to have more than 2 temp dbspaces to be able to spread the load of temp tables. It just becomes redundant doing it with fragmentation, when the underlying striping lights up all the disks for every access anyway. Cheers, -- Mark. +----------------------------------------------------------+-----------+ | Mark D. Stock mailto:mdstock@MydasSolutions.com |//////// /| | Mydas Solutions Ltd http://MydasSolutions.com |///// / //| | +-----------------------------------+//// / ///| | |We value your comments, which have |/// / ////| | |been recorded and automatically |// / /////| | |emailed back to us for our records.|/ ////////| +----------------------+-----------------------------------+-----------+ sending to informix-list