asp.net性能问题 [英] asp.net performance question

问题描述

在xml文件中选择或在sql server中选择



哪个更好？

select in xml file or select in sql server

Which is better؟

推荐答案

1这个问题与.Net无关。

2）没有明确的答案。

如果xml文件是通过网络获取的非常大的文件，则SQL查询可能会更快。

如果xml文件很小并且在本地缓存，请选择在xml中会更快。

也可能有很多其他因素在这里发挥作用。

1) This question has nothing to do with .Net.
2) There is no clear answer.
If the xml file is a very large file that is fetched over the network, a SQL query might be faster.
If the xml file is small and cached locally, select in xml will be faster.
There could be many other factors playing a part here as well.

你将苹果与橙子进行比较。 XML不是数据库引擎，也不是为存储关系数据而设计的。



您提出的问题的答案在很大程度上取决于可能因素，尤其是其中包括您的数据集的大小以及您正在使用它做什么。



您的问题也与ASP.NET完全无关。

You're comparing apples to oranges. XML is not a database engine and is not designed to store relational data.

The answer to your question you're asking is highly dependent on may factors, not the least of which is the size of your dataset and what you're doing with it.

Your question also has absolutely nothing to do with ASP.NET.

这篇关于asp.net性能问题的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！