NEED TO KNOW: Is it better to save 100 thousand+ images in OS or in BLOB field
Posted on 2005-04-27
From a performance perspective, I would like to know what is more efficient. I will be
storing hundreds of thousands images in my database. These images range in size from
2k to 10k. Each image will be updated as often as once per week.
I know that there have been a lot of questions on this subject, but the quantity of
images I am dealing with is greater than what I have seen discussed on EE so far.
It seems that the general answer is to always store only the image path in the DB
and store the actual image in Windows. My question is whether Windows file system
can actually handle that many images in a directory without slowing down or dying.
BTW, I am using ASP 3.x on Windows Server 2003.