I completely disagree with this approach. While it would be logically fine if
you NEVER plan on doing anything but storing these images, consider this:

- If you need to view an image, how are you going to do it? Are you going to
make every eligible person carry around a special program?
- If you need to edit an image... see above
- When your boss starts saying "I want to email this image to person X", how are
you going to handle it?
- If for some reason the images need to change format, you can't use a good old
file system bulk converter... anything will have to be a custom application
- It will take you much further towards any limits there are for database size
and its objects
- A few key bytes corrupted in the database could render any amount of the
images to be inaccessible (granted, you should back this up)

There are LOTS of things to consider. Just remember, the users of the world use
a file system to store their images... and your job probably entails dealing
with said people.

Jason

Dennis Mulder wrote:

> 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/>.
>>
>>
>>------------------------------------------------------------------------
>>
>
>
>
>
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
> 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
>
>
>
>
>
>
>
>