Storing and retrieving pdf files

[cricketer1]

I have many pdf files which are to be stored in the database or the OS filesystem, but need to be accessed quickly by front end application. Is it possible to store pdf data in SQL Server or will the OS filesystem be a better option and how can I give fast access to this pdf data.

Thanks
Cricketer1

 

[mrdenny]

You can store any binary file such as pdf, jpg, doc, etc in a SQL Server field with the data type of image.

I would however recommend storing the files on the web servers hard drive, and only storing the relative path to the file in the SQL Server. This will keep the disk load on the SQL Server low, as well as not pound on the SQL Server's memory. Let the web server store and display the files, since that's what it's designed to do.

Denny

--Anything is possible. All it takes is a little research. (Me)

 

[NoCoolHandle]

It also makes it easier to hack.

Webservers file systems have a good reputation for being compromised.

But yes it is easy to store things there. The webserver does support options like caching and load ballencing.

However if you are looking for "How" to do it from the db side check out the post on the same topic in this forum about 4 days ago. All the code you need is there.. you would just point to the ShowDoc.aspx file in the same way you reference and use the pdf doc.

For what it is worth.

Rob

 

[NoCoolHandle]

Ok so inside the thread it talked about pdf's

the thread id =

http://www.tek-tips.com/viewthread.cfm?qid=951036&page=1

 

[cricketer1]

Thanks NoCoolHandle...I have checked out the code in the old thread and it's pretty neat.

and thanks mrdenny, I will evaluate both options and see which one works better for me..

cricketer1