[comp.databases] Performance of UNIFY on NCR Towers

converse@rlgvax.UUCP (Steve Converse) (10/17/87)

I'm trying to optimize UNIFY running on a Tower 32/600.  I was wondering
if anyone in Netland could advise me on the following:

1) How much would it help to put our 60 megabyte database on a separate
file partition, avoiding UNIX's file system overhead?

2) What is the optimal setting for the system parameters given that we
have 8 megabytes of memory?

Also, has anyone had any experience with UNIFY's fourth generation language,
Accel.  (I'm not sure if that's the name or not, just guessing.)

Thanks for any information.

P.S. I'm no longer at this address; please send replies to :

Steve Converse
Computer Consoles
converse@rlgvax

George Skillman (rlgvax!brahms)

Elric@tsc3b21.UUCP (Frank ) (10/22/87)

in article <665@rlgvax.UUCP>, converse@rlgvax.UUCP (Steve Converse) says:
> 
> I'm trying to optimize UNIFY running on a Tower 32/600.  I was wondering
> if anyone in Netland could advise me on the following:

And I'm trying to just optimize UNIFY!

> 1) How much would it help to put our 60 megabyte database on a separate
> file partition, avoiding UNIX's file system overhead?

The documentation says that performance is quite a bit better -- but I have
yet to test this.  As I am currently installing UNIFY on a pair of IBM RT's
with over 400MB available on twin drives, I will be attempting to find an
optimum configuration.  I'll let ya' know...

> 2) What is the optimal setting for the system parameters given that we
> have 8 megabytes of memory?

Funny you should ask.  Our customer decided to buy two RT's.  IBM told them
(this is secondhand) that the best configuration was 16MB of RAM and 72MB of
disk on one machine, and 4MB of RAM and 400MB+ of disk storage.  I don't
know if IBM's suggestion came from UNIFY themselves or from deep in the
heart of IBM (if that's possible ;-)).

I suspect that after we have the system installed and running for a few days
that we'll change it to something more reasonable...

> Also, has anyone had any experience with UNIFY's fourth generation language,
> Accel.  (I'm not sure if that's the name or not, just guessing.)

We bought for the demonstration version of ACCELL (yes, that's the name)
but my colleague here and I just don't appreciate it, if you know what
I mean.  It is probably a quite handy tool since after the forms are
defined there isn't much left to do unless you have some unusual flow
or something.

> Thanks for any information.
> 
> Steve Converse
> Computer Consoles
> converse@rlgvax
> 
> George Skillman (rlgvax!brahms)

No problem.  I hope it helps.

"Use the Source, Luke.   Feel it flow through your fingertips..."
------
Frank (crash) Edwards
...!codas!usfvax2!{pdn,jc3b21}!tsc3b21!{Elric,crash}
TSC in Palm Harbor, FL
(The Sweat Shop [with a 'C'])
Phone:  (813) 785-0583  (voice)