Application State, Public Static/Shared Member or Database
Posted on 2012-03-14
I have many pages on my site that draw data from a DB, there are small parts of text in places on the page that are user entered and editable but do not change very often, stored in the DB.
I can't cache the pages as the other data on the page needs to be in real time, but can I store these pieces of text else where?
If when the web app starts if I get all these pieces of text and store them in app state/static member would this increase performance? Or is there a better way to go about it?
Also if this text is updated can I have a method that will update the app state/static member so the changed text becomes available without restarting the app?