RE: user space

["DeLong, Eric" <EDeLong@xxxxxxxxxxxxxxx>]

Hi, welcome to the list.  This is the place for RPG, all versions except
VARPG, which has its own list.

Regarding your program, I don't think caching to a userspace object will
really help you that much.  Database I/O in RPG is highly optimized, and I
wouldn't really bother unless there is a real problem with run times.

Have you looked at SETOBJACC?  It forces an object to be kept in main
storage.  

There are many factors to examine when looking for performance gains, so
there may be other approaches to look at, such as DB I/O, keyed -vs- arrival
sequence, record length (size of the data-sets), etc.   

Eric DeLong
Sally Beauty Company
MIS-Project Manager (BSG)
940-898-7863 or ext. 1863



-----Original Message-----
From: Mihael Knezevic [mailto:m.knezevic@porta.de]
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.