Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 127
  • Last Modified:

VB.net and SQL Storing Images: Database or Folder

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
Murray Brown
Asked:
Murray Brown
  • 3
  • 2
1 Solution
 
Pawan KumarDatabase ExpertCommented:
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
 
Murray BrownMicrosoft Cloud Azure/Excel Solution DeveloperAuthor Commented:
Great. Thanks for validating that
0
 
Éric MoreauSenior .Net ConsultantCommented:
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
What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

 
Murray BrownMicrosoft Cloud Azure/Excel Solution DeveloperAuthor Commented:
Thanks Eric. Sorry I couldn't award points
0
 
Éric MoreauSenior .Net ConsultantCommented:
no problem. it is just another more modern option I wanted to let you know
0
 
Murray BrownMicrosoft Cloud Azure/Excel Solution DeveloperAuthor Commented:
Appeciated. Thanks
0

Featured Post

 [eBook] Windows Nano Server

Download this FREE eBook and learn all you need to get started with Windows Nano Server, including deployment options, remote management
and troubleshooting tips and tricks

  • 3
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now