Save Image in the server

Question

0.00/5 (No votes)

See more:

, +

Hello friends.
I am working on a asp.net project and Oracle as my back end Database.In the application I am working on, I have to upload images and save it in the server.I have to make a choice between saving the images in the Oracle database or as separate file in the server and save only the image path in the database.
Which option is the best one?Any help is highly appreciated.
Thanks in advance.

Posted 5-Jan-12 2:40am

Pallab_GT

Updated 5-Jan-12 11:48am

Wonde Tadesse

v2

Add a Solution

3 solutions

Solution 1

I think saving the image in database is the best option. rather than saving the image in file system and the file path in database. cause if the image files needs to be moved to a differet location of the server ( due to some space crunch or somthing) all the path references stored in the DB needs to be updated. But in case you save the whole image file in DB as binary format, the data (the image files) is already present in your system.

Posted 5-Jan-12 2:52am

senguptaamlan

Solution 3

This is vary biased opinion :) but I would actually do both. Instead of writing the image inside the database I'd use a BFILE to store the image to a folder and also to have the pointer in the file created at the same time. For more information see: Working with LOBs and BFILEs[^]

Posted 5-Jan-12 10:01am

Wendelius

Comments

Espen Harlinn 5-Jan-12 16:38pm

The "Professional" solution :)

Wendelius 5-Jan-12 17:15pm

Thanks, probably not the easiest to implement, but a lot of fun :)

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)

Om Prakash Pant · Accepted Answer · 2012-01-05T02:54:00

Solution 2

this article will help you to decide the same:

http://research.microsoft.com/apps/pubs/default.aspx?id=64525[^]

If also depends on the usage of images. if the image size is less than 200 KB, then you can use database otherwise use filesystem.

Posted 5-Jan-12 2:54am

Om Prakash Pant