Can anybody give me an opinion on which is more efficient -
Saving parameters in a database that is on the same machine as the web site
or
Reading parameters from a .config file ?
It seems like the constant opening/closing of the connection would be a
congestion spot - plus it would use lots of memory.
But when you have the options in a file - is that slow there?
Is this a spot where a cache would be appropriate ? I would like it for both
web services and for a web site. In theory I could load the cache when
somebody goes to the login page and then read from then on. But how do I
update it when new values are stored? The values don't change that often.
TIA - Jeff.