Search:  
NamespacesDiscussions.NET v1.1Feedback
Best Practices
Messages   Related Types
This message was discovered on ASPFriends.com 'aspngarchitecture' list.


Administrator
Hello All,

Here is a best policies question.

I have a website where users will be able to upload images.
The files are all checked at time of upload to insure that they are all less than 50k in size.
I could potentially have several hundred thousand images. (Perhaps a few million.)
At some point I may upgrade to a server farm if user load calls for it.

My question is: Is it better to store the images on a hard drive in a centralized location, or perhaps store them in a SQL database?

Currently I am storing them all in a SQL database, but I am concerned that the load of a 98% dynamic site and the photos might put on the SQL server.

Any ideas?

Thanks,

John

P.S. Thank you for the ideas about figuring out the size of photos. Unfortunately with saving the images in a SQL database, the extra steps of saving it to the web server just to find out it size doesn't seem worth the hassle.
Reply to this message...
 
    
Graham Dobson
Hello All,

Here is a best policies question.

I have a website where users will be able to upload images.
The files are all checked at time of upload to insure that they are all less than 50k in size.
I could potentially have several hundred thousand images. (Perhaps a few million.)
At some point I may upgrade to a server farm if user load calls for it.

My question is: Is it better to store the images on a hard drive in a centralized location, or perhaps store them in a SQL database?

Currently I am storing them all in a SQL database, but I am concerned that the load of a 98% dynamic site and the photos might put on the SQL server.

Any ideas?

Thanks,

John

P.S. Thank you for the ideas about figuring out the size of photos. Unfortunately with saving the images in a SQL database, the extra steps of saving it to the web server just to find out it size doesn't seem worth the hassle.
Reply to this message...
 
 




Ad
MBR BootFX
Best-of-breed application framework for .NET projects, developed by Matthew Baxter-Reynolds and MBR IT
 
 Copyright © Matthew Baxter-Reynolds 2001-2008. '.NET 247 Software Development Services' is a trading style of MBR IT Solutions Ltd.
Contact Us - Terms of Use - Privacy Policy - www.dotnet247.com