where to store big data?
-
Hi all, I create a application that use SQL to store documents like picture files, sound files...Should i use image data type to store these files or just the path to the file or something else? please help me to figure out the best solution. Thank in advance!
-
Hi all, I create a application that use SQL to store documents like picture files, sound files...Should i use image data type to store these files or just the path to the file or something else? please help me to figure out the best solution. Thank in advance!
-
Sure you have to use Image datatype. The Image data type can store up to 2GB of binary data, which also enables it to store standard text data.
-
Thank albCode, but can you compare the performance btw 2 solutions: 1. Store the whole file in Image datatype field. 2. Store the path to the file only.
You need to think about how youe application will be used. Storing the file will make queries etc a lot slower but in some cases it may be the only way. If you store the path only then each client will need to be able to access that path (typically using a mapped drive). So if you are using a purely server based application like a web app or even a small LAN based client server application storingthe path may be best. Jon
-
Sure you have to use Image datatype. The Image data type can store up to 2GB of binary data, which also enables it to store standard text data.
If you use SQL2005 you should use varbinary(max). image should not be used any more. Rainer Stropek Visit my blog at http://www.cubido.at/rainers