Storing image in folder is the best option?

Question

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 24-Jul-18 16:41pm

Member 13922689

Updated 25-Jul-18 5:18am

Add a Solution

3 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

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

MadMyche · Answer 1 · 2018-07-25T04:22:00

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

Patrice T · Answer 2 · 2018-07-25T05:19:00

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.

RossMW · Answer 3 · 2018-07-24T17:15:00

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.

Storing image in folder is the best option?

3 solutions

Solution 2

Solution 3

Solution 1

Add your solution here

Preview 0