Avatar of ankurdk

asked on 

Ideal way of storing large number of .jpg images

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.

Microsoft SQL ServerWindows OSSQL* images

Avatar of undefined
Last Comment
John Tsioumpris

8/22/2022 - Mon