Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Package Data vs Global Variables

Package Data vs Global Variables

From: William Teo <sucheeha_at_singnet.com.sg>
Date: Wed, 5 Jan 2000 12:34:03 +0800
Message-ID: <84uhig$t9i$1@coco.singnet.com.sg>


Hi,

Currently I am working on a security module and the design of the program requires me to store all user rights(previllege) in as flags. When security checks in required, I simply reference these pre-initialised flags.

One solution is to initialised a list of global variables and set the flag when the form is first instantiated. Another solution is to declare this list of flag in a package data section and then initialised it also when the form start up.

My question is which method is better?
By storing the list of variables(possibly ~100s) in a package, it will be available throughout the session. But that will take up memory on the server side !
Assuming I have 60 users, wouldn't it have a severe impact on the server performance?

Thanks. Received on Tue Jan 04 2000 - 22:34:03 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US