Our largest image database has over 500,000 images stored as blobs
spread across 2 tables (1 for pdf, 1 for tiff) and is approximately 95
GB. We have had no problems with performance or reliability so far...

-steve

paultugwell 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?
>
>
>
>
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
> Visit http://firebird.sourceforge.net and click the Resources item
> on the main (top) menu. Try Knowledgebase and FAQ links !
>
> Also search the knowledgebases at http://www.ibphoenix.com
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
> Yahoo! Groups Links
>
>
>
>
>
>
>
>
>
>