哪个更快:文本文件或MS SQL [英] which is faster: Text Files or MS SQL

问题描述

我需要将从设备接收到的信息保存在日志文件中.该设备每秒发送大量帧，因此保存所有帧非常重要.现在，这些框架将保存到顺序文本文件中.

重要的是保存所有框架，后续操作暂时不重要.

在这种情况下:与使用文本文件相比，直接在SQL中存储数据可能会提供更好的性能?形式将是愚蠢的，但是您可以将其以二进制数据的形式存储在文件中.无疑，这将比使用SQL更快.

—SA

我们还在致力于记录器.如果是文本文件，当文件大小超过MB时，您将面临许多问题.在我们的案例中，日志文件的大小从 MB 调整为 GB .搜索非常困难.如果您不想在日志上执行任何搜索或过滤操作，则最好使用TextFile，否则使用SQL.

希望这些信息对您有帮助，

谢谢
-Amit

I need to save, in a log file, information received from a device. This device sends a large number of frames per second and is very important save them all. Now, these frames are being saved to a sequential text file.

The important thing is save all the frames, subsequent actions does not matter for now.

In this case: Storing the data directly in SQL may provide better performance than using text files???

解决方案

Storing who-knows-what which requires speed in any text form would be plain stupid, but you could store it in files in the form of binary data. That would be faster than using SQL, most certainly.

—SA

Hi,

We are also working on logger. in case of textfile you have to face so many problems when file exceeding size in MBs. in our case log file sizing from MBs to GBs. Searching is very difficult. if you do not want to perform any search or filter operation on your log then TextFile is preferable otherwise SQL.

hope this information is helpful to you,

Thanks
-Amit

这篇关于哪个更快:文本文件或MS SQL的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！