Subject Blobs
Author paultugwell
I am about to add to an application the ability to store scanned
documents. There will be 10-12,000 documents per annum. The documents
will be held in a database containing only a single table which will
contain the document stored in a blob field and some other fields to
index the documents so that they can be retreived. Is this a sensible
approach? Can FB cope with this and are there any problems or pitfalls
of which I should be aware? Alternatively, I could store the documnets
on disk as jpg's or pdf's, with an entry in the database indicating the
file name. Is this a better approach?