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
Printable View
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
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.