Subject | Blobs |
---|---|
Author | paultugwell |
Post date | 2006-04-04T12:08:27Z |
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?
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?