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