Re: NBRRCDS and BLOCK(*YES)

 You are right Rob.  It was Input/full, not Input Primary.

If he is looking for blazing performance my suggestion would be to drop the
use of the join logical and go with IP and IS files with matching record
logic.  So far I have seen nothing that comes close to matching that for
performance.



---------------------------------------------------------
Booth Martin   http://www.MartinVT.com
Booth@MartinVT.com
---------------------------------------------------------

-------Original Message-------

From: rpg400-l@midrange.com
Date: Monday, December 23, 2002 11:51:28
To: rpg400-l@midrange.com
Subject: Re: NBRRCDS and BLOCK(*YES)

This is a multipart message in MIME format.
--
[ Picked text/plain from multipart/alternative ]
Booth,

Was that blocking on a Primary file, though?

I've found that using a Primary file (where applicable) is an astounding
increase in performance.

Rob Berendt
--
"They that can give up essential liberty to obtain a little temporary
safety deserve neither liberty nor safety."
Benjamin Franklin




"Booth Martin" <Booth@MartinVT.com>
Sent by: rpg400-l-admin@midrange.com
12/23/2002 11:42 AM
Please respond to rpg400-l

To: <rpg400-l@midrange.com>
cc:
Fax to:
Subject: Re: NBRRCDS and BLOCK(*YES)


NBRRCDS(3)?? a very small file?

What is it you are looking for? Performance improvements? Have you taken
out the K?

My experience with Block(*yes) was a revelation. It provided close to 70%
reduction in processing time in two different applications. I was
astounded




---------------------------------------------------------
Booth Martin http://www.MartinVT.com
Booth@MartinVT.com
---------------------------------------------------------

-------Original Message-------

From: rpg400-l@midrange.com
Date: Monday, December 23, 2002 06:58:54
To: rpg400-l@midrange.com
Subject: NBRRCDS and BLOCK(*YES)

Hello Everybody,

Can anyone clarify me regarding:

My programs uses a file in update and primary mode. The file is a join
logical file. All records being read in processed and updated.
Record length is 3768

"1) Can I specify NBRRCDS or BLOCK(*yes)
2) If I specify NBRRCDS(3) in OVRDBF and specify BLOCK(*yes) in F specs
for
the same file, which will be effective ?
3) Which one is beneficial.

thank you in advance