FileStream Experiences

  • Hello All,

    Has anyone used FileStreams to store large binary objects in a SQL Server database. What has been the experience.

    I have found documentation which lists some limitations of the technology...

    However I want to know your experiences in general with the technology.

    Do you think we are better off by keeping the large binary files out of the DB... or can we attempt.

    (By large files I mean 2GB files.)

  • I've used it for large files, but not quite that large. Worked very well for multi-meg files.

    - Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
    Property of The Thread

    "Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon

Viewing 2 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply