Upload to database or not to database?

thachnn · October 11th, 2004, 02:59 AM

Dear All,
I have ASP.NET project to store/display about 40.000 image (28KB/1 image).Must i store them to database( image SQL data type)? Or store it indirectly,out side databse?
If i store 1 image 28 KB ,how size is it in database?
Quickly please and thanks alot!

Anantsharma · October 11th, 2004, 08:13 AM

HI,

If I were u, I would have store images separately in a folder. No need to put extra burden on SQL Server. Better U maintain the path for image in Database or in an XML file and use that to retrieve the image.

Image or BLOB is heavy data types.Also these creat complexity in ASP code.

B. Anant