> 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 assume that you're talking about automatic masters?

> 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.

Sounds like at least one of the chains is sorted, and the data is not.
Because of the way IMAGE adds to sorted chains, inserting random data
is an O(N^2) operation. If that's the case, pre-sorting the data (in
DESCENDING order) to the maximum extend possible (requires a stable
sort if doing multiple sorts on multiple chains) should significantly
improve your load time.

> 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.

Possible, but I certainly wouldn't "guess" that secondaries or chain
length are a problem--especially since all of the database tools can
tell you exactly, no guessing required.

* To join/leave the list, search archives, change list settings, *
* etc., please visit http://raven.utc.edu/archives/hp3000-l.html *