RE: user space

["Bob Cozzi" <cozzi@xxxxxxxxx>]

You can create and array or table that uses a user space for its memory.
I actually cover that very topic in tomorrow's edition of my Midrange
Developer newsletter. Go to www.mcpressonline.com/midrangedev to read it
tomorrow if you are not a subscriber (subscription is free).

On the question of whether or not it is faster, well you can set the NBRRCDS
and the second part of the SEQONLY parameter of the OVRDBF command to a
larger number of records. This causes it to act somewhat like a cache and
tells the override that you're going to be reading in those reads so keep
them in memory. But single-level storage actually handles it.

Bob

-----Original Message-----
From: rpg400-l-bounces@midrange.com [mailto:rpg400-l-bounces@midrange.com]
On Behalf Of Mihael Knezevic
Sent: Tuesday, January 21, 2003 6:27 AM
To: RPG programming on the AS400 / iSeries
Subject: user space


hi rpg400 list,

i'm quite new and inexperienced to rpg (especially rpg iv) so sorry for the
newbie questions.

my first question: is this list only for rpg400 or also for rpg iv
(previously named ile rpg) ?

i got the following situation:
my programm accesses to tables. one table is read from top to bottom, every
record, and has about 15000 records. the second table is accessed about
every 10th record and has only 30 records.

now my second question: would it be better to read the necessary data from
the second table into a userspace object? if so, how do i store and access
it from the userspace object. or are there any other way to have less
database access/workload. it seems to me that it would be faster to first
store the data in some temporary memory. though i could be wrong, cause that
would be the way i would do it on a PC and i know that it's a big
difference.

i'm thankfull for every suggestion.

thanx in advance.

mk

_______________________________________________
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/mailman/listinfo.cgi/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.