Re: Temporary dbspaces

In article <3576713C.79705C38@jonners.cix.co.uk>, Jonathan Myatt <jon@jonners.cix.co.uk> wrote: > > A quick question for the gurus... > > If I have four temporary dbspaces defined, will a large sort which > creates a large temporary table use all four, or can the temp table > not "span" dbspaces? Would I be better off consolidating the available > space into two bigger temp dbspaces? > > TIA > > Jon. > Informix will automatically fragment temporary objects accross the available temp dbspaces. Also, if your application is heavily utilizing the temporary space, then you are better off having multiple temp dbspaces to reduce contention. Ideally, you want to be sure to create your temp dbspaces on different devices. Tim "Just my opinion, NOT that of my employer" -----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/ Now offering spam-free web-based newsreading