Yaro schrieb:
Hi
We intend create system to store documents in company.
Size of documents: 100k-2M, hundred thousands or milions files.
We are considering the possibility to store documents in DB2 or in
filesystem.
Can anybody share your experience?
What is performance solution with files in db? Have you any problems with
that?
I am looking for articles, links, hints, advantages and disadvantages for
this solutions.
Thanks in advance
Yaro
I created a DMS system and I decided for myself, to store the documents
NOT within the database. After 6 years of usage I've about 450000
documents with about 800000 renderings (a document can be available in
different renderings ... formats). These documents need about 80GB
(or compressed 50 GB) for themselves.
The database itselfs (project oriented document management system)
needs about 1.2 GB.
When goig this way, one has to consider how to store the files within
the filesystem. Especially, when a Windows system is the server.
Unix/Linux systems have no performance problems with such large number
of files, but a Windows server can step into big trouble here.
Having the files within the filesystem also means, that you have to
have a transfer path from the storage server to the client, looking
fo a special file.
I do not assume, that you want to have these files in mounted
filesystem, visible for all users !?
One way could be FTP (remember XP-SP2 firewall !) ...
Having the file in filesystems, make them very easily to backup :-)
Marten