file or filename in db?

manared

Well-known member
Joined
Jun 1, 2006
Messages
84
Programming Experience
1-3
I have a web application (VS 2008, .NET 3.5) that I need to create. There are a bunch of different search criteria (specs of drawings) that users can search for and when they search for the results, a list will come up with all the matching results with all the specs and either one or two files related to each result. My confusion right now is the question of whether i should put the files directly into the sql database or just the location name of the file. I can save the files in the actual database, but we don't know if that may eventually take up too much room and make the server slow. I could put the name of the location of the file in sql that points to the file. But in the past we've had problems with rights and access to the files. Users aren't able to download the files. Does someone know how to fix that? Or any suggestions on what I can do?
 

Latest posts

Back
Top