Click here to Skip to main content
15,920,438 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
For Web application, i want to store more than 500 images.can some one help me, storing in binary format in sql OR storing image in folder is the best option?


What I have tried:

For Web application, i want to store more than 500 images, can some one help me, storing in binary format in sql OR storing image in folder is the best option?
Posted
Updated 25-Jul-18 5:18am

What works best is all going to depend on how you plan on using it.

As for SQL Server, handling the BLOB data is no big deal.
The question is how much overhead will this cause your website.

If these images are going to be used often; I generally recommend to store the image in the filesystem and a (relative) location in the DB. This not only reduces the work for the web-application running the site, but it will generally allow the images to be cached in the users browser, which will be a positive for the site performance metrics
 
Share this answer
 
Quote:
Storing image in folder is the best option?

The File System is made to store files by design, and since pictures/images are static, chances are that their handling will be more efficient than storing them in a database.
Since webpages are naturally using links to get pictures, you will have the server sending them on request without any particular handling on server.
 
Share this answer
 
if your question is just

Quote:
storing in binary format in sql OR storing image in folder is the best option?


then
500 images should be child's play for a SQL server. Storing them in a SQL server will also give added security via the database rather than the file structure security the web server will need to keep to ensure everything safe and usable.
 
Share this answer
 
v2

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900