My view as well - all apps that do this are moving away or have moved away from this SQL method.
-----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: Tuesday, September 19, 2006 10:57 PM To: [email protected] Subject: 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. ------------------------------------------------------------------------ --- ------------------------------------------------------------------------ --- --------------------------------------------------------------------------- ---------------------------------------------------------------------------
