XML vs SqlServer

[diegojancic]

Hi,
Anyone knows the performance deferences between accessing to a XML and getting a small Table with a simple query from MSSQL... Or other Dbs, such Oracle or MySQL (Using the .NET Driver from mysql.org)

Thanks,
Diego

[xenofex]

if you decide to use xml, you should read the xml file as stream. If you use xpath it may be a little bit slow. I think you should use the sql server or any database.

You can store the connectionstring or database connectivity information in the xml file. Because in the future the table might be larger. Therefore xml file is not valid purpose.