RE: user space -- RPG400-L

1) yes
2) yes (it's a really small program)
3) because of it's size -> yes
4) as we don't have a shop standard (cause we ain't a shop) i think i
could say yes
5) for that programm -> no (cause it's finished) otherwise -> yes, of
course =)

and i take your last statement as a compliment. thanx

-----Original Message-----
From: Walden H. Leverich III [mailto:WaldenL@TechSoftInc.com] 
Sent: Wednesday, January 29, 2003 3:10 PM
To: 'RPG programming on the AS400 / iSeries'
Subject: RE: user space


>the programm runs quick enough. there are no performance problems. it's

>more the second part of your last sentence: to do it right.

OK, I know I'm about a week behind here, but I'd point out the
following:

1) Does the program solve the busines need? 
2) Does the program run "quick enough"? (really part of #1)
3) Is the program easy to maintain in the future?
4) Does the program follow "Shop standards"?
5) Do you have anything else on you list of ToDo's? (Who doesn't)

If you answered "yes" to these questions the you have "done it right"
and should leave it alone. If not then the other suggestions have been
excellent.

I would also point out however, that an increase in performance gained
from moving to something like an user index has to be ballanced against
the loss of "ease of maintenance." If I had to guess, I'd say less that
1% of the RPG programmer base has even heard of user indexes, let alone
used them. (Oh, and I don't think the number of people that have heard
of user spaces is much larger)

-Walden

------------
Walden H Leverich III
President
Tech Software
(516) 627-3800 x11
(208) 692-3308 eFax
WaldenL@TechSoftInc.com
http://www.TechSoftInc.com 

Quiquid latine dictum sit altum viditur.
(Whatever is said in Latin seems profound.)
 

-----Original Message-----
From: Mihael Knezevic [mailto:m.knezevic@porta.de] 
Sent: Tuesday, January 21, 2003 10:04 AM
To: RPG programming on the AS400 / iSeries
Subject: RE: user space


the programm runs quick enough. there are no performance problems. it's
more the second part of your last sentence: to do it right.

and to learn more about userspace would also be nice. but i think you're
right. i'll take a look at the archives.

thanx.

mk

-----Original Message-----
From: Richard B Baird [mailto:rbaird@esourceconsulting.com] 
Sent: Tuesday, January 21, 2003 2:33 PM
To: RPG programming on the AS400 / iSeries
Subject: Re: user space



Mihael,

there are other rpg lists, but this is the only one i use.

as far as using a user space for your table file, that seems to me to be
a bit of overkill, unless your goal is to learn more about userspaces. A
better option might be loading the file into an RPG table.

there was a large thread on this list a month or so ago that talked
about what to do in this situation.  If i remember correctly, the
concensus was that chaining to a 30 record file many multiple times, you
would gain little by loading the file into a table.

It was something about the as/400 single level store - after the 1st
(pick a number) chains to your table file, the database optimizer would
recognize that this was a file that is going to be used a lot, and would
leave it in resident memory for easy access.

15000 records is not a large number of records to process, and 15000/10
chains is also not a huge number for chains.   this program should run
fairly quickly (easily under a minute?) on a right-sized iseries.  even
faster if run in batch.

are you having performance problems with this program?  or are you just
writing it and want to do it right the first time?

hth,

rick

-------original message-------
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.


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