Re: Storing Images in SQL Server (2005)



I would suggest using views to control access

In my experience storing and retrieving images from MS SQL is significanly slower compared to pulling images via a file system.

I use ADO stream object to retrieve the images and stream them directly to the end user browser, I do not use a temporary file. Too hard to come up with unique names for the temporary file for each user, plus you have clean up of the temporary files.

---------------------------------------------------------------------------
---------------------------------------------------------------------------