Skip to content
  • Categories
  • Recent
  • Tags
  • Popular
  • World
  • Users
  • Groups
Skins
  • Light
  • Cerulean
  • Cosmo
  • Flatly
  • Journal
  • Litera
  • Lumen
  • Lux
  • Materia
  • Minty
  • Morph
  • Pulse
  • Sandstone
  • Simplex
  • Sketchy
  • Spacelab
  • United
  • Yeti
  • Zephyr
  • Dark
  • Cyborg
  • Darkly
  • Quartz
  • Slate
  • Solar
  • Superhero
  • Vapor

  • Default (No Skin)
  • No Skin
Collapse
Code Project
  1. Home
  2. Database & SysAdmin
  3. Database
  4. FIlestream of varbinary ? ( To Store files)

FIlestream of varbinary ? ( To Store files)

Scheduled Pinned Locked Moved Database
databasesysadminquestion
4 Posts 3 Posters 0 Views 1 Watching
  • Oldest to Newest
  • Newest to Oldest
  • Most Votes
Reply
  • Reply as topic
Log in to reply
This topic has been deleted. Only users with topic management privileges can see it.
  • A Offline
    A Offline
    Amol_B
    wrote on last edited by
    #1

    After reading several documents , i am still confused whether to use Filestream or Varbinary for storing files? my application need PDf files to be saved in database , size can be between 100 KB to 4 MB I guess in order to use filestream we have to configure server to use that. while varbinary can work as it is. what will be best way?Experts please comment. Thanks.

    L M 2 Replies Last reply
    0
    • A Amol_B

      After reading several documents , i am still confused whether to use Filestream or Varbinary for storing files? my application need PDf files to be saved in database , size can be between 100 KB to 4 MB I guess in order to use filestream we have to configure server to use that. while varbinary can work as it is. what will be best way?Experts please comment. Thanks.

      L Offline
      L Offline
      Lost User
      wrote on last edited by
      #2

      Take a look at http://sqltales.wordpress.com/2012/05/15/varbinary-vs-filestream-and-other-blob-issues-3/[^].

      Use the best guess

      1 Reply Last reply
      0
      • A Amol_B

        After reading several documents , i am still confused whether to use Filestream or Varbinary for storing files? my application need PDf files to be saved in database , size can be between 100 KB to 4 MB I guess in order to use filestream we have to configure server to use that. while varbinary can work as it is. what will be best way?Experts please comment. Thanks.

        M Offline
        M Offline
        Mycroft Holmes
        wrote on last edited by
        #3

        We use filestream only to reduce the size of the database backup which is retained for some ridiculous number of years! documents are backed up seperately.

        Never underestimate the power of human stupidity RAH

        A 1 Reply Last reply
        0
        • M Mycroft Holmes

          We use filestream only to reduce the size of the database backup which is retained for some ridiculous number of years! documents are backed up seperately.

          Never underestimate the power of human stupidity RAH

          A Offline
          A Offline
          Amol_B
          wrote on last edited by
          #4

          Thanks +5

          1 Reply Last reply
          0
          Reply
          • Reply as topic
          Log in to reply
          • Oldest to Newest
          • Newest to Oldest
          • Most Votes


          • Login

          • Don't have an account? Register

          • Login or register to search.
          • First post
            Last post
          0
          • Categories
          • Recent
          • Tags
          • Popular
          • World
          • Users
          • Groups