c# - Which one is faster reading an XML file or querying a database -
I am preparing CMS in C # and need to decide where to save the configuration settings for the site . Also consider defining my base HTML templates and then processing the server side to make the page ahead of time. So what is the faster / less overhead from the server or the local database to read an XML file? It seems that this will be a hindrance in your code. How often are you planning on reading the configuration settings? The configuration is generally enough , and sometimes reads more important things to think about where it and how to store it: Bootstrapping: You can probably access your app's local file system, and you hard-code a configuration file name ... but if all your configuration is in the database, then what database do you configure to talk to Are you Tweaking and ease of deployment: A configuration editing server may be , faster than making changes in the database. ..but if you have multiple servers, do you want to zoom a file on each one of...