Application Custom Configrations

I'm not sure which would provide the best performance as well as an industry accepted solution. I have an application that is being used by a variety of customers now. Since we are now using  a single code base I need to allow the customer(s) to configure options such as menu names, the mileage rate that they will pay for mileage as well as others. Is it accepted to utilize the web.config file to store the settings or should I go with a database solution? I've been reading a little on this subject and haven't really had my questions answered.
Which would provide the following:
* Easier to implement
* Provide performance increase (as far as setting/retrieving settings)
* Is one preferred over the other
Trent AdamsApplication EngineerAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Shaun KlineLead Software EngineerCommented:
If you are hosting a single website for multiple customers, then adding these settings to the web.config is not the answer. Web.config is for application wide settings, such as connection strings or email server settings. Also, depending on whether you have any software auditing or project management requirements, changing the web.config file could be considered another release of software.

Storing these types of settings is generally done in a database. This allows for updates to the values when needed quickly without the need to change code files.
1

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Trent AdamsApplication EngineerAuthor Commented:
Shaun, thank you for your response. I was looking into utilizing KVP's in a database, so your response follows my thought process. Thanks again.
0
Trent AdamsApplication EngineerAuthor Commented:
Response makes sense and follows the research that I've done prior to asking the question as well as follows the track in which I was considering going down for this software release.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
ASP.NET

From novice to tech pro — start learning today.