RE: Retrieval of data from memory

["Saunders, Robin" <robin.saunders@xxxxxxxxx>]

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.