|
Joel, That would be fine, but you might consider storing the stuff in a user index and then using the MI instructions to access the index and get the values. You could also use the APIs to get the entries but that's a little counterproductive since the overhead of the program call to the API probably would diminish anything gained by using the indexes. Bob Cozzi Cozzi Consulting www.rpgiv.com -----Original Message----- From: rpg400-l-bounces@xxxxxxxxxxxx [mailto:rpg400-l-bounces@xxxxxxxxxxxx] On Behalf Of Joel Cochran Sent: Wednesday, October 29, 2003 10:06 AM To: RPG programming on the AS400 / iSeries Subject: User Spaces Along the lines of the recent thread regarding DataQueues, I'm trying to determine whether or not to use User Spaces for a particular project. They sound intriguing, but having never used them before I'm not sure if they are correct for this application: For a new application we are writing there will be a security configuration file. Each user will have authorities set at the option and function key level. Naturally this is all DB driven, but in essence each authority gets verified at three differenct levels. At screen display time to determine whether or not to display an option; at option processing time to verify that the user did not select an unauthorized option, and at processing time to make sure that no back doors were taken in getting there. Given that this processing will need to take place for every screen, selection, and processing, it appears to me that this may be overly burdensome on the DB. So to bring this back to User Spaces, I'm wondering if it would be better for us to read the authorities in once when the user signs into the application, store them in a User Space unique to that log in, and then access the user space for the verification instead of the DB. I'd probably create the User Space in QTEMP so that the GC is taken care of automatically. Would this be faster, better, etc, or am I making a mountain out of a mole hill? Thanks, Joel http://www.rpgnext.com _______________________________________________ This is the RPG programming on the AS400 / iSeries (RPG400-L) mailing list To post a message email: RPG400-L@xxxxxxxxxxxx To subscribe, unsubscribe, or change list options, visit: http://lists.midrange.com/mailman/listinfo/rpg400-l or email: RPG400-L-request@xxxxxxxxxxxx Before posting, please take a moment to review the archives at http://archive.midrange.com/rpg400-l.
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.