troubleshooting Question

Ideal way of storing large number of .jpg images

Avatar of ankurdk
ankurdk asked on
Microsoft SQL ServerWindows OSSQL* images
10 Comments1 Solution108 ViewsLast Modified:
We have a large number of .jpg images (about half a million! and growing) each of size upto 200 KB.  We have a Windows based application WITH SQL SERVER 2008 as BACKEND, which accesses these images not all at once but on demand (for e.g: on click of a button) NOW we have two options to access these images :

1) We store images in SQL Database in bit form.

2) We store images physically on Windows Drive on Server and access their path.

Which of these or otherwise for that matter would be the best way to store and access these images not compromising on SPEED of accessing since they all are located in the SAME location!  Any suggestion for an ideal way of storing images are also welcome.

David Johnson, CD
The More I know, the more I don't know
Join our community to see this answer!
Unlock 1 Answer and 10 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 10 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros