RE: Storing Images in SQL Server (2005)



My view as well - all apps that do this are moving away or have moved
away from this SQL method.

-----Original Message-----
From: listbounce@xxxxxxxxxxxxxxxxx [mailto:listbounce@xxxxxxxxxxxxxxxxx]
On Behalf Of mmaples3@xxxxxxxxx
Sent: Tuesday, September 19, 2006 10:57 PM
To: focus-ms@xxxxxxxxxxxxxxxxx
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.

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

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