Solved

VB.net and SQL Storing Images: Database or Folder

Posted on 2016-10-18
6
81 Views
Last Modified: 2016-10-19
Hi

I have a client that uses a cloud SQL database that I set up for them. They need to store a number of images on a daily basis.
I was thinking of two ways to do this:
1. Insert each image into a varbinary field within  a SQL table
2. Store the images in a folder in their website and then just store a path to this image in a nvarchar field in SQL

Which is better? The second method feels right.
0
Comment
Question by:murbro
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 2
6 Comments
 
LVL 28

Accepted Solution

by:
Pawan Kumar earned 500 total points
ID: 41849508
2. Store the images in a folder in their website and then just store a path to this image in a NVarchar(255) field in SQL

is the best solution. Don't go with the first one. First one requires huge size and image management is also difficult.
0
 

Author Closing Comment

by:murbro
ID: 41849511
Great. Thanks for validating that
0
 
LVL 70

Expert Comment

by:Éric Moreau
ID: 41849999
there is another option I really like. it is called FileTable: http://emoreau.com/Entries/Articles/2012/12/Microsoft-SQL-Server-2012-FileTable.aspx
0
Salesforce Has Never Been Easier

Improve and reinforce salesforce training & adoption using WalkMe's digital adoption platform. Start saving on costly employee training by creating fast intuitive Walk-Thrus for Salesforce. Claim your Free Account Now

 

Author Comment

by:murbro
ID: 41850372
Thanks Eric. Sorry I couldn't award points
0
 
LVL 70

Expert Comment

by:Éric Moreau
ID: 41850380
no problem. it is just another more modern option I wanted to let you know
0
 

Author Comment

by:murbro
ID: 41850466
Appeciated. Thanks
0

Featured Post

Best Practices: Disaster Recovery Testing

Besides backup, any IT division should have a disaster recovery plan. You will find a few tips below relating to the development of such a plan and to what issues one should pay special attention in the course of backup planning.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

It was really hard time for me to get the understanding of Delegates in C#. I went through many websites and articles but I found them very clumsy. After going through those sites, I noted down the points in a easy way so here I am sharing that unde…
The Delta outage: 650 cancelled flights, more than 1200 delayed flights, thousands of frustrated customers, tens of millions of dollars in damages – plus untold reputational damage to one of the world’s most trusted airlines. All due to a catastroph…
Using examples as well as descriptions, and references to Books Online, show the documentation available for date manipulation functions and by using a select few of these functions, show how date based data can be manipulated with these functions.
Viewers will learn how the fundamental information of how to create a table.

738 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question