Hello All,
im looking to find the best technique to use for the following scenario i believe this is going to be best using application level variables.
Scenario:
I have a table in a database with roughly 100 rows (increasing constantly) they are all holding integers.
These rows all hold a global setting for the application i am developing for the web. These settings will affect all users.
These settings will not be changed often.
They are basically used as flags to decide appropriate actions set by admin E.G. export a report to PDF not WORD or vice versa.
I Believe the best way to achive what i am after is to add code to the global.asax file for ON STARTUP of the application to query the database for all these items and set them.
If modified through the admin section these could then be set directly.
Is this the best option for me to choose.
I will be holding 32bit Integers and the number of settings will increase. Will i have any performance issues/setybacks using this method? cheers.