which way is best to store image in sql server database

Question

0.00/5 (No votes)

See more:

What datatype should be used to store images in database? Or
Store only the path using varchar datatype and place images in specific folder.
I am very confuse for storeing image.
please help me out.

Posted 19-Jun-11 18:36pm

Sonje Girish

Add a Solution

1 solution

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)

thatraja · Answer 1 · 2011-06-19T18:39:00

Solution 1

Here you go

Storing Uploaded Files in a Database or in the File System with ASP.NET[^]

My suggestion is File system.

Posted 19-Jun-11 18:39pm

thatraja

Comments

Ankur^\m/ 20-Jun-11 1:09am

Good link.
And about your suggestion - most of the times file system will be the option, but it really depends on lot of factors. There are lot of discussion about the same on the web. One such here - http://brian.moonspot.net/2007/10/19/putting-files-into-a-database/
My 4!

thatraja 20-Jun-11 1:17am

/*but it really depends on lot of factor*/
Of course Agree, it's true fact for all things.

But based on personal experience I prefer file system which is easy to handle. Also storing files db increases the db file size & it makes slow to handle(I have worked in one project - storing images in db) & faced some issues at that time.
BTW Thank you man.

Ankur^\m/ 20-Jun-11 1:36am

I would store "sensitive" and small files in db. :)

thatraja 20-Jun-11 1:38am

But requirement may be change soon like large files ;-)

Ankur^\m/ 20-Jun-11 1:40am

And so I mentioned - "it depends on lot of factors".

thatraja 20-Jun-11 1:49am

Already agreed ;-)

uttam2010 20-Jun-11 1:26am

File System bcoz.. u may need to keep your thumb & long image sizes on server.its retrieval will be easy.

thatraja 20-Jun-11 1:27am

Of course.