RE: Index build speedup

A couple quick items to check. Do an onstat -g mgm and check the DS_MAX_QUERIES, DS_MAX_SCANS, and DS_TOTAL_MEMORY parameters. You may need to increase these. As you adjust one (using onmode) watch your quantum values...you want small quantum values. I usually just work with the query and memory parameters. And of course, table fragmentation plays a key role here. HTH rrabe > ---------- > From: Carlson@WHSmith[SMTP:carlson1@bellsouth.net] > Reply To: Carlson@WHSmith > Sent: Tuesday, December 07, 1999 2:01 PM > To: informix-list@iiug.org > Subject: Index build speedup > > OS: HPUX 10.20 > IFX: IDS 7.30.ucX > HDWE: HP G70 (2-way box) > > I'm in the process of tightening up various aspects of my reorg scripts > (dbspace level). I've been able to use HPL as necessary, so unloads > (and probably loads) will run in a more optimum fashion. One of the > more time-consuming aspects of the reload process is the index build. > > I've seen various recommendations concerning PDQPRIORITY, etc. Here's a > snippet of what I used: > > Test1: > I verified that PSORT_NPROCS was set to 4. When this benchmark began, > the system allocated 4 segments of shared memory (8M each). Total run > time was 1:13:29. > > Test2: > I increased SHMVIRTSIZE by 36M, bounced the system and reran. I saved 3 > minutes. > > Test3: > I set PDQPRIORITY to 100. My ONCONFIG variables were: > MAX_PDQPRORITY 100 > All of the DS_* variables were set to default. > It took two hours to create two of the seven indices. > > Even though I've heard that PDQ will speed up an index build, I haven't > seen it in this test system. Since others have had a noticeable change > (for the better), I must have missed something. Any ideas? > > Thanks in advance > > > John Carlson > Informix DBA > WHSmith USA >