473,326 Members | 2,815 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,326 software developers and data experts.

Document Storage

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.
Jul 21 '05 #1
1 1156
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.

Jul 21 '05 #2

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

8
by: Sandy Norton | last post by:
Hi folks, I have been mulling over an idea for a very simple python-based personal document management system. The source of this possible solution is the following typical problem: I...
1
by: Patrick Conway | last post by:
Hi! I'm building a Windows form that allows users to view a list of files (and their properties(metadata)) stored in a certain directory. All of the files in the directory are a result of a...
0
by: Sivaraman.S | last post by:
Issue: When I am opening a word document or a template from an ASP.NET Web page (language used VB.NET Visual Studio Version 2003) using Word.ApplicationClass object (Reference Word 11.0 object...
8
by: Asma | last post by:
Dear Sir, I am trying to find a way to open a Word document using C language and read the text of word doc into a variable. (Turbo C on Dos 6.0). Can anyone please tell me which libraries in...
0
by: Sivaraman.S | last post by:
Issue : When I am trying to open a Word Document or a Template from a Web Application (ASP.NET Web page - Language Used VB.NET Visual Studio Version 2003) using Word.ApplicationClass (Refering...
1
by: Hugh McLaughlin | last post by:
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...
3
by: Hallgeir Stuenes | last post by:
I'm trying to understand the differences between a XML document archive versus a relational data base. What are their advantages and disadvantages? - Hallgeir
2
by: Andy | last post by:
Hi, I have an XML document that uses namespaces (it is from a Word 2007 file). I want to retrieve all the "t" elements that belong to the "w" namespace (<w:t>) using XPath from VB.NET 2003 (.NET...
1
maxamis4
by: maxamis4 | last post by:
Hey folks, I am in the process of mapping and developing a document repository. I wanted to know if there was one that was already made out there and if so where? If not I have a couple ideas...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.