Document Storage

  • Thread starter Thread starter Hugh McLaughlin
  • Start date Start date
H

Hugh McLaughlin

Hello Everyone and thanks for your help in advance. I am
developing a document storage application for an intranet
that will store various Word, Excel, and PDF documents.
Most of the examples I see utilize SQL Server and an
image field rather than the FileSystem Object to store
documents. My concern with this method is that some of
the documents may be several hundred pages (not exactly
sure of the actual file size yet, but they must be fairly
large). My question is, where does the use of SQL Server
become impractical for this type of application? Any
insight would be greatly appreciated. Thanks.
 
Hi Hugh,

I guess using databases in general for storing large records is almost
always not practical.
If you don't need transactions I would consider storing only links (paths)
to documents which should be stored somewhere on disk (on the server of
course).
 
Back
Top