Document Storage

[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.

[Miha Markic]

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).

--
Miha Markic - RightHand .NET consulting & development
miha at rthand com
www.rhand.com

"Hugh McLaughlin" <an*******@discussions.microsoft.com> wrote in message
news:08****************************@phx.gbl...

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.