Subject Re: [firebird-support] Files or FDB to store images?
Author Dennis Mulder
I would recommend storing the images in the database and not on the hard
disk with file location in the database.
Although retrieving images from a directory on the HD is faster (from
what I have heard) and is a lesser load on the server, but since your
system is not heavily used you would be better off storing the images in
the database. It's easier to maintain and to move to a different system
if need be.

Dennis


Dariusz Zelichowski 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
>
>
>
>
>
>
> ---------------------------------
> Yahoo! FareChase - Search multiple travel sites in one click.
>
> [Non-text portions of this message have been removed]
>
>
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
> 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
>
> * Visit your group "firebird-support
> <http://groups.yahoo.com/group/firebird-support>" on the web.
>
> * To unsubscribe from this group, send an email to:
> firebird-support-unsubscribe@yahoogroups.com
> <mailto:firebird-support-unsubscribe@yahoogroups.com?subject=Unsubscribe>
>
> * Your use of Yahoo! Groups is subject to the Yahoo! Terms of
> Service <http://docs.yahoo.com/info/terms/>.
>
>
> ------------------------------------------------------------------------
>