On 3/14/14, 9:25 AM, Dave Crozier wrote:
Because storing them in the standard file system with pointers to them is:
1. Slow .... access times deteriorate as the depth of the tree and number of
documents in each folder increases
Perhaps it depends on the filesystem?
2. Potentially insecure. I know you can lock down the data via group policies etc and we
did in fact do this when we used a "pointer system" but it is a potential
insecurity.
Perhaps the database is potentially insecure, too?
3. Data in a filesystem if present is by nature by definition insecure once
accessed as files can be moved, renamed etc.
I wasn't thinking the *user* would have direct access to the files.
4. Access of documents (blobs) direct from sql is a lot lot faster than folder
access and the data can be mirrored/clustered automatically as opposed to
having to set up external folder synchronisation. We in fact mirror our main
SQL database so down time and disaster recovery i.e 100% uptime (as we are on a
3 node SAN) is totally covered
"A lot lot faster" was point 1. Files in a filesystem can be mirrored
very easily and quickly using tools such as rsync.
5. Shipping around data in SQL server and setting up internal OCR recognition
with the scans is easier
Perhaps...
6. Network Disconnects can and do happen when the "pointer system" is used.
Network disconnects can and do happen with anything you do on the network...
Files are files. By putting them in the database you are essentially
reimplementing the filesystem there. I could see some benefits to doing
this, but I'm not sure they outweigh the cons of losing all the
filesystem tools at my disposal.
Paul
_______________________________________________
Post Messages to: [email protected]
Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message:
http://leafe.com/archives/byMID/profox/[email protected]
** All postings, unless explicitly stated otherwise, are the opinions of the
author, and do not constitute legal or medical advice. This statement is added
to the messages for those lawyers who are too stupid to see the obvious.
