I always used FILESYSTEM
blobs are a pain and they bloat the table size unnecessarily
>Hi Guys,
>
>I came across a prospective client who needs to have their documents managed, i.e., stored centrally, accessed quickly via a search facility, viewed or downloaded or even printed.
>
>The documents are of various types - tax returns, corporate papers, business permits etc - of 100 stores.
>
>I am aware that this query has been asked before, but in your experiences, which is the way to go - store the documents (scanned as Jpegs or PDFs usually) - in BLOB columns? Or merely let them reside in the computer's File System?
>
>In my readings, it seems these are two opposing views.
>
>Your suggestions please!
>
>Thanks.
Peter Cortiel