Re: Indexing speed

Barry Leb wrote: > What are you temp spaces like? I have found that more smaller temp > spaces vs fewer larger ones improve index build performance. However, > there is a tradeoff There are some Informix operations that can only > use a single temp dbspace.(Unfortunately, I can't recall what they are > at this time). In this situation it is best to have the largest temp > dbspace you can configure - 2gig. No, just as with any other dbspace, I think a temp dbspace can consist of multiple 2GB chunks. Just a qustion of how much space you want to dedicate to temp dbspaces. June -- june_t@hotmail.com Grounded in Palo Alto, living on Cafe Mocha