--- In firebird-support@yahoogroups.com, "paultugwell" <pault@...> wrote:

>
> 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?
>

I currently have 17000 documents stored in blobs and it works nicely.
These documents are text files of between 1 to 10 a4 pages .
If you have pdf, doc or other formats it maybe better to store them
outside of the database depending on how often you need to access them.
Storing picture files is also no problem at all . I have abt 20000
fotos in jpg format stored in blobs .
Hope this helps.