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-01-03 : 17:59:08
|
Mike writes "I am considering 2 approaches to uploading (avg 3K-40K) from a browser and displaying or serving files (most images) to a browser, both using ASP and ASPUploadCOM to facilitate the file upload.
1) Simply store a pointer to the file and save the file in the IIS web directory, this is the current method.
2) Save the actual file in the database.
Whith Option 2 I have the following questions.
1) How do I Select the file and get it to the client?
2) When I retrieve the file can IIS or the browser cashe the file?
3) What Data Type(s) should I use.
4) Are there performance issues (avg 400 images/files per table)
Notes: The main reason I am considering this is simplicity when it comes to overlapping names and sorting files into directories so I don't have 400 files in one folder, and portability, accessing the images from different webs without making copies of the existing files.
You thoughts are greatly appreciated,
Mike" |
|
|
|
|
|
Storing and Retieving files in SQL Server 7 via ASP