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#