×
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.
We have a number of programs, some in RPG/400 and others in RPG IV, that
load reference data from various files into arrays in an attempt to
reduce the performance impact of multiple chains to database files.
The trouble with this approach is that the arrays are limited in size, a
maximum 9,999 elements in RPG/400 and 32,767 elements in RPG IV.
One thought was to use the arrays for the first however many records
would fit and then chain to the database file for the remaining records,
but there's concern about the performance impact of that approach.
An alternative is to make use of user indexes, which could provide a lot
more space for storing entries, but we're not sure on the performance
impact of that approach.
Does anybody have any knowledge of the performance benefits and pitfalls
of any of these approaches? What do others do when faced with the same
problem?
Thanks
Jonathan Mason
_______________________________________________________
This message was sent using NOCC v1.14 webmail software
_______________________________________________________
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.
midrange.com
