Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Package Data vs Global Variables
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
![]() |
![]() |