在 ADO.NET 中，序列化 DataTable 还是 DataReader 更好？
我在一个表中有静态数据，必须对其进行序列化。我经常读到，如果您希望获得仅遍历一次的只读数据，则 DataReader 的性能更高。但是，如果您希望序列化此信息，DataTable 会更好吗？
I have static data in a single table which I must serialize. I have often read that a DataReader is more performant, if you wish to have read-only data that you traverse only once. If you wish to serialize this information however, would a DataTable be better?
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（2）
“更好”是一个权衡的问题。可以使用
WriteXml()方法“序列化”数据表中的数据。问题解决了。如果您准备调整性能，您可能会通过为读者编写自定义序列化器来获得一些成果，但您会用开发时间来换取（我们希望）改进的性能。
"Better" is a matter of trade-offs. Data from a data table can be "serialized" by using the
WriteXml()method. Problem solved.If you're up to tuning the performance, you might get some mileage by writing a custom serializer for the reader, but you exchange development time for (we hope) improved performance.
为每个场景编写一个小测试，并使用与正常操作期间看到的数据尽可能接近的数据。
然后运行测试并测量其性能。您收集的数据将帮助您做出决定是否以性能为重中之重。
Write a small test for each scenario and use data that is as close to the data that you will see during normal operation.
Then run the tests and measure their performance. The numbers you gather will help you to make a decision if performance is the top priority.