Subject: | |
From: | |
Reply To: | |
Date: | Wed, 26 Dec 2001 09:13:47 -0700 |
Content-Type: | text/plain |
Parts/Attachments: |
|
|
I have a IMAGE data set with 2 masters.
The detail had 135,000,000 and a capacity of 185,000,000 when I started. I turned off the TPI (OMNIDEX) transaction manager.
Then I use Adager to expand the capacity of the detail set to 213,000,000.
The 2 masters I expanded to 30% full.
I am using SUPRTOOL, OPEN the base MODE 3.
PUT with SET DEFER ON.
I have 2 files to load 37 million and 27 million.
On my test of the first 5 million records I got 5,200 puts per min., which is what I got in the first 5 million records. I am at 8 million records now. I am getting about 2000 puts per min.
Any Idea's why I am slowing down.
I guess that the number of master records associated with the number of detail is causing long chain length. Which would cause the CPU a lot of work.
Box is 937SX 5.5 PP6
Kent Wallace
Boise Id.
* To join/leave the list, search archives, change list settings, *
* etc., please visit http://raven.utc.edu/archives/hp3000-l.html *
|
|
|