× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.



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.



As an Amazon Associate we earn from qualifying purchases.

This thread ...

Replies:

Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.