Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2001-05-20 : 22:59:34
|
Hunter writes "We are trying to determine the best way to store files within our system, by storing a 'path' to the file in the database table which gets passed to the client application which then retrieves the file OR storing the files directly within the database in an image column. I see that SQL Server will allow ful text searches on certain files types stored in image data, and that using the database gives you transactional integrity, and this is a scalable solution.
However, we have concerns that the retrieval of image data will become a performance problem over time as the number of files grows and are not sure if there are other concerns that we are not aware of.
Thanks" |
|
|
|
|
|
Storage of Files in SQL Server 2000