Re: 12+ hours index.

"Shannon Sellers" <ssseller@concentric.net> wrote: >We have a system with 54 million records. Building an index takes over 12 >hours. Is this an acceptable time or do we have a problem? it seems extreme >to me! >The system is a 4 pentium pro running AT&T unix with I believe 128 meg of >ram and something like 72 Gig of harddrives. >I don't work on this system, but wondered if it should really take that >long. > Thanks Shannon We had a similar size table on a Sun system with long index builds - 9 hrs. However we have 10 cpus and 512 meg memory. We have gotten our index builds down to 1 hr. We did this doing 2 things. The greastest bang for the buck was increasing the amount of temp dbspaces as specified by the DBSPACETEMP variable. Initially, we bumped the dbspaces from 8 to 14. The dbspaces were 500,000 meg each. Recently we upgraded our OS and reconfigured all our drives. Now I have 16 temp dbspaces at 250,000 each. We found that by increasing the amount of temp dbspaces gave us better index performance than just having several large spaces. The second thing that we do is set PDQPRIORITY very high when building the index. Usually the setting is 80, but we have at times of low system activity set it to 100. Barry Leb National Linen Service 1420 Peachtree Street MS #314 Atlanta, GA 30309 (404) 853-6119 (404) 853-6485 fax e-mail: barryleb@mindspring.com