Ethical Hacking

Learn to find vulnerabilities before the bad guys do! Gain real world hands on hacking experience in our state of the art hacking lab. Course designed and taught by expert instructors with years of penetration testing experience. 12 student maximum in every class. Certification attempt included in every package.
Computer Forensics Training at InfoSec Institute

Gain the in-demand skills of a certified computer examiner, learn to recover trace data left behind by fraud, theft, and cybercrime perpetrators. Discover the source of computer crime and abuse at your organization so that it never happens again. All of our class sizes are guaranteed to be 12 students or less to facilitate one-on-one interaction with one of our expert instructors.




Network Security Focus-Microsoft
[Top] [All Lists]

RE: Storing Images in SQL Server (2005)

Subject: RE: Storing Images in SQL Server (2005)
Date: Wed, 20 Sep 2006 09:36:21 -0500
My view as well - all apps that do this are moving away or have moved
away from this SQL method. 

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

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

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


<Prev in Thread] Current Thread [Next in Thread>