We store both TIFF images and PDF images. I am not sure of the sizes of
the image files... The total size of the databases is about 190 GB.
The are split across 9 servers though as the images belong to different
clients.

We don't do gbak backups of the databases. We sweep them nightly and
back them up to tape (shut down access to the servers when we do this to
prevent corruption).

We did store the images in a file system once, but it started choking on
10,000 or so files. I was faced with having the apps start creating
folders automatically and coming up with a plan to do this and still be
able to find the images or store them in the db. We tried the db and so
far it has worked out great.

-steve

On Sat, 2005-10-29 at 22:49 +0200, Aage Johansen wrote:

> Steve Wiser wrote:
> > We image over 1 million documents a year (about 35% are multipage)
> and
> > we store them in databases. No problems so far, performance is
> good, no
> > corruption. Overall we are happy with the decision (ease of
> security,
> > storage, etc.). However we don't manipulate the image once it is
> > stored, just retrieve.
>
>
> What are the size of the images, and total size of database.
> What about backup - how often, how long does it take?
>
> We use a system where images are stored as files, yearly increase is
> (probably less than) 150.000. Like your system, images (once stored)
> are
> just retrieved.
> In another situation I store images in a database, and as you say,
> it's
> very convenient.
>
>
> --
> Aage J.
>
>
> ------------------------ Yahoo! Groups Sponsor
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
> 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
>
>
>
>
>
>
>


[Non-text portions of this message have been removed]