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



On Tue, 2003-01-21 at 12:26, Mihael Knezevic wrote:
> hi rpg400 list,

Hi Mihael

> 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) ?

It's more of an RPG on the AS/400 (iSeries) list than a list just for
RPG400, so RPGIV discussion is fine.

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

So the second file gets around 1500 reads, during the course of the
program? 

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

Why use a user space for just a small amount of records? In similar
situations I've preloaded an array with the records from the small file,
then done my lookup to the array instead of a chain to the file. I
haven't any benchmarks to back it up, but subjectively it seems far
faster and more efficient.

Regards, Martin
-- 
martin@dbg400.net  AIM/Gaim: DBG400dotNet  http://www.dbg400.net       /"\
DBG/400 - DataBase Generation utilities - AS/400 / iSeries Open        \ /
Source free test environment tools and others (file/spool/misc)         X 
[this space for hire]  ASCII Ribbon Campaign against HTML mail & news  / \


As an Amazon Associate we earn from qualifying purchases.

This thread ...

Replies:

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.