CODEWITHSUNDEEP
sqlsql-server
Michael
Michael

Reputation: 8729

Storing PDF In Database Or Hard Drive

I have a webpage that stores Scanned PDF files. At the moment I store it in the Sql Database with as a varbinary.

I am redesigning everything from scratch and was thinking it may be more efficient to store the PDF's on the hard drive and just have a path..

The PDF collection, potentionally could get to 500gig+..

which is more efficient and what are the advantages either way?

Upvotes: 0

Views: 1112

Answers (2)

Russell Fox
Russell Fox

Reputation: 5435

Look into using FILESTREAM to store the files in a database-accessible way on the file system: Using FILESTREAM to Store BLOBs in the NTFS File System in SQL Server 2008

Upvotes: 1

Hairgami_Master
Hairgami_Master

Reputation: 5539

I would use a persistent store such as AmazonS3. It's cheap, replicated, and if you change your database technology at some point in the future, it will be fairly easy. Instead of storing the files directly in your database, store the URL of the PDF on your AmazonS3 storage.

Upvotes: 1

Related Questions