HP3000-L Archives

December 2001, Week 4

HP3000-L@RAVEN.UTC.EDU

Options: Use Monospaced Font
Show Text Part by Default
Show All Mail Headers

Message: [<< First] [< Prev] [Next >] [Last >>]
Topic: [<< First] [< Prev] [Next >] [Last >>]
Author: [<< First] [< Prev] [Next >] [Last >>]

Print Reply
Subject:
From:
KENT WALLACE <[log in to unmask]>
Reply To:
KENT WALLACE <[log in to unmask]>
Date:
Wed, 26 Dec 2001 09:13:47 -0700
Content-Type:
text/plain
Parts/Attachments:
text/plain (28 lines)
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 *

ATOM RSS1 RSS2