Re: Array efficiency (was:Dynamic Arrays)

Read the help text for SETOBJACC, Booth...

Gary's right:  When I was working at Office Depot in 1995, we were analyzing
JDE programs in order to make recommendations about changes needed to
improve efficiency.

IBM representatives (CE's) recommended that the quickest way to improve
performance on the system was to add additional memory to the system and use
SETOBJACC to force all records from certain files into memory because of
disk-arm contention problems, program efficiency problems, etc.

We ended up with a dual solution...we used SETOBJACC to force certain files
into memory, as well as making program modifications to some the of worst
offenders to make them more efficient.


----- Original Message -----
From: "Booth Martin" <Booth@MartinVT.com>
To: <rpg400-l@midrange.com>
Sent: Thursday, October 17, 2002 12:30 PM
Subject: Re: Array efficiency (was:Dynamic Arrays)




 Could you go in to more details?  There are folks I know that would love to
improve response times by adding memory.  Why hadn't their salesman
suggested that instead of recommending a new and larger box?

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

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

From: rpg400-l@midrange.com
Date: Thursday, October 17, 2002 01:22:43 PM
To: rpg400-l@midrange.com
Subject: Re: Array efficiency (was:Dynamic Arrays)

Not necessarily. Creating a memory rich environment and using SetObjAcc
to keep things in memory is not so outlandish. SetObjAcc can make a huge
performance difference. If that's critical, well...

Gary Guthrie


Booth Martin wrote:
>
> wow. wow. have you heard any results? That sounds like a really naive
> solution to a very complex problem.


Rob wrote:

> I have heard several times lately about companies buying huge quantities
> of memory for their iSeries in an attempt to load their entire database
> into memory to speed access.
>
> Now, whether they are using arrays or some other method of paging in the
> entire database is a different issue.

_______________________________________________
This is the RPG programming on the AS400 / iSeries (RPG400-L) mailing list
To post a message email: RPG400-L@midrange.com
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/cgi-bin/listinfo/rpg400-l
or email: RPG400-L-request@midrange.com
Before posting, please take a moment to review the archives
at http://archive.midrange.com/rpg400-l.

.
_______________________________________________
This is the RPG programming on the AS400 / iSeries (RPG400-L) mailing list
To post a message email: RPG400-L@midrange.com
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/cgi-bin/listinfo/rpg400-l
or email: RPG400-L-request@midrange.com
Before posting, please take a moment to review the archives
at http://archive.midrange.com/rpg400-l.