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
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. 3. Data in a filesystem if present is by nature by definition insecure once accessed as files can be moved, renamed etc. 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 5. Shipping around data in SQL server and setting up internal OCR recognition with the scans is easier 6. Network Disconnects can and do happen when the "pointer system" is used. And those are just off the top of my head. Dave -----Original Message----- From: ProFox [mailto:[email protected]] On Behalf Of Alan Bourke Sent: 14 March 2014 16:12 To: [email protected] Subject: Re: [NF] M$ SQL Server Remote Blob Store On Fri, Mar 14, 2014, at 04:09 PM, Paul McNett wrote: > I'm curious as to why storing documents in a filesystem (and storing > references to them in your database) is less than ideal. It seems to > me you are properly separating concerns by doing it that way. > I too am curious! [excessive quoting removed by server] _______________________________________________ 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.
