超过2 GB的SQL文本文件 [英] Over 2 GB text files with SQL

问题描述

你好，



我正在为生物信息学领域建立一个网络工具。我必须处理每个文件超过2 GB的DNA序列文件，我会有几十个文本文件。我会有一个DB来保存这些DNA。我的问题是，读取txt文件并将其内容存储在表记录中是否更有效，或者存储txt文件的路径并在每次需要访问它时读取它？还是有另一种方式？

我正在使用SQL server 2008，VS 2010 asp.net和c＃

Hello,

I''m building a web tool for bioinformatics field. I have to deal with DNA sequence files which will exceed 2 GB for each file and I''ll have dozens of text files. I will have a DB that keep these DNAs for me. My question is will it be more efficient to read the txt file and store its content in a table record or store the path of the txt file and read it every time I need to access it ?? or is there another way ?
I''m using SQL server 2008, VS 2010 asp.net and c#

推荐答案

可能存储文件的路径更好，但既然你没有解释你将如何访问和使用数据，这很难说。



例如，您的客户是否只是阅读整个文件并使用每一个或者您希望索引所有这些数据并搜索它的随机部分？



还有更多的信息要求，而不仅仅是什么是最好的存储方式...

Probably storing the path of of the file would be better, but since you haven''t explained anything about how you''re going to access and use the data, it''s pretty hard to tell.

For example, are your clients just going to read the entire file and use every bit of or are you expected to index all of this data and search for random parts of it??

There''s a lot more information require than just "what''s the best way to store this"...

这篇关于超过2 GB的SQL文本文件的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！