Configuration Application Block - SQL versus XML File

  • Thread starter Thread starter Steve
  • Start date Start date
S

Steve

When using the configuration application block what are the pros and
cons of using a SQL configuration provider as opposed to an XML file
configuration provider. In what situations sould you use one over the
other.

Any information or current documentation on the matter would be
greatly appreciated.

Cheers,

Steve
 
The main benefit of SQL over a file is the ability to take advantage of SQL's
availability and scalability. The XML file is a bit easier to edit, as you
can simply use a tool like notepad (if you know XML). You also can secure
configuration information from prying eyes more easily.

XML will beat SQL, on loading, as it is on the local file system, but load
time is not a big issue with config info. We are also talking milliseconds
per hit.

---

Gregory A. Beamer
MVP; MCP: +I, SE, SD, DBA

***************************
Think Outside the Box!
***************************
 
Back
Top