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.

-steve

On Fri, 2005-10-28 at 18:39 -0300, Valdir Marcos wrote:

> One of my clients had 40 thousand images (jpg, between 40 and 200kb)
> in Win XP Pro.
> One image is the front of document, the other is the back of the same
> document, so in 40 thousand records there were 20 thousand records
> with images , growing 70 new records a day (140 images).
> Before importing these images into FB 1.5.2, we had problems in
> performance of the application itself, backup and replication because
> of the huge amount of entries in one folder.
> When we imported all the images to FB, the performance got excellent
> in the same Win XP Pro.
> Now, we just experience problems of using Win 2003 SE...
>
> Best regards,
>
> Valdir Marcos
>
> ----- Original Message -----
> From: Ali Gökçen
> To: firebird-support@yahoogroups.com
> Sent: Friday, October 28, 2005 9:39 AM
> Subject: [firebird-support] Re: Files or FDB to store images?
>
>
> Hi,
> In my opinion, store all of them in a FDB.
> 1. It will be compact at physical and logical level
> 2. You will not disturb the OS file list with huge entries.
> 3. You can decrase application complexity by using only a FDB.
> 4. You will prevent broken file links
> 5. There is no storage saving with using external jpg files.
> 6. It will be more fast.
> 7. It will be more portable.
> 8. It will be more backup/replication-friendly.
> etc...
>
> Regards.
> Ali
> --- In firebird-support@yahoogroups.com, Dariusz Zelichowski
> <z_darius@y...> wrote:
> >
> > Hi,
> >
> > My employer is considering digitizing a bunch of existing
> > records contained on index cards. OCR is not an option as
> > the cards are in various formats and contain handwritten
> > notes. One of the steps required is scanning all the index
> > cards and then... this is where I am not sure what to do.
> >
> > Should I store resulting images (after they are scanned) as
> > jpeg files linked to relevant database entries, or would it
> > be better to store the images inside a firebird database as
> > records.
> >
> > These are some of the technical aspects of the project:
> >
> > - about 20,000 index cards
> > - each card generates 2 files (one for each side)
> > - each file is between 40KB and 200KB
> > - the data growth rate will be very modest (no more than 30
> > a day)
> > - access to the database will be only sporadically by more
> > than one person at a time.
> > - at the present time all the cards to be scanned would
> > require approx. between 2GB and 6GB of disk space if stored
> > in jpeg format (depending of the resolution of the scan)
> >
> > Any comments/suggestions will be appreciated.
> >
> > Dariusz
>
>
> [Non-text portions of this message have been removed]
>
>
>
> ------------------------ 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]