× 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.



Thanks for the advice. I also tried to get performance improvements by
sharing ODP's, but didn't notice any real difference. Does the group think
that the iSeries is better at managing the ODP's than manually opening and
override for SHARE before executing the programs.

TIA

Robin

-----Original Message-----
From: Booth Martin [mailto:Booth@MartinVT.com]
Sent: Tuesday, December 24, 2002 12:36 AM
To: rpg400-l@midrange.com
Subject: Re: Retrieval of data from memory



 As others have said, leave it up to the hardware to sort out.

Or, use a different paradigm to solve the problem.  One choice that jumps to
mind is that you write one program that loads all records into its memory
and does exactly the processing you want done.  A parm_in with the
DataStructure filled in as much as possible, and then filled by the program
and returned to the calling program, would resolve your issue?

Especially if you did it as one of those new-fangled procredure things?  Or
did it as a dataque? Either would be an awesome solution in my mind.


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

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

From: rpg400-l@midrange.com
Date: Monday, December 23, 2002 02:33:56
To: Rpg400-L (E-mail)
Subject: Retrieval of data from memory

Hi all,

I need to write a program that reads data into memory, as this data is
accessed many 10,000's of times a day and so I am trying to avoiding
constant access of the data on disk. There is no fixed limit on the number
of records in the file, but probably would be a maximum of 100.

I thought of using an array and lookup op. code on the key of the file. Is
there any better ways of achieving my desired result?

Also, would managing the memory allocation for the array make a significant
difference to performance?

TIA, and Happy and relaxing Holidays to all.

Regards,
Robin
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~



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


_______________________________________________
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 ...


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.