storing design file (contents) in sql server and performance
Posted on 2012-03-31
I'm writing a code which is dealing with dxf files (basically is a text file generated by AutoCad). now, in a part of the project I need to store it. Its contents can be something like:
however, it gets to several thousands of lines. I'm thinking of saving it in a field as Varchar(MAX) which supports up to 2GB of information.
Can an expert advise me on this?
the code will read dxf files from an input and stores them in sql server 2008 and yet it has to be able to reopen and show the design. this make me think of storing the files on storage device and instead store only the path/file name in the database since there will be more steps that have to go through connecting to the database, locating the data, reading the contents and creating a temp dxf file. Any advice?