0

I'm developing an application that needs to store large images and about 100 image a day about 3 people work on the same application DB (desktop application connected to same db)

any one of theme can view , edit, delete other work which means all of theme can access certain image at once

now the question is what is the best way to store images this big (currently I'm storing the images in a table but i know this eventually will suck)

I'm using sql server 2008

Alaa Jabre
  • 1,843
  • 5
  • 26
  • 52
  • possible duplicate of [Store tiff images in SQL Server or file system?](http://stackoverflow.com/questions/1234551/store-tiff-images-in-sql-server-or-file-system) – Conrad Frix Dec 16 '11 at 19:59

1 Answers1

4

You could use the new in v2008 FILESTREAM data type to store your images. This is a hybrid approach that means the data can be queried from SQL, but the data itself is stored in the filesystem rather than in the database.

D'Arcy Rittich
  • 167,292
  • 40
  • 290
  • 283