Thanks Adan for reply.

My application this being developed in Delphi.
I would like to store the images directly in the database.
The same ones would have between 50kb and 1mb.
Each registration (patient in that case) would have between 20 and 50 images.

best regards,

Marcelo

Ps.: (Excuse my terrible English!)



Adam <s3057043@...> wrote:--- In firebird-support@yahoogroups.com, Marcelo Machado
<machado6655@y...> wrote:

>
> Dear friends,
>
> Something simple that stores pictures in a bank firebird (already

developed)

>
> I need to store some 50 pictures for registration in the bank
>

Marcello

Giving your programming language would help people respond with
something you can use. Also you need to say what expected formats the
pictures will be (.jpg / .png / .gif / .psd / .tif / etc). Is it 50,
or 50 per customer, and if 50 per customer, how many customers? What
is the average file size of the pictures.

You need to decide whether to store the pictures in the database or to
simply store a path to the pictures in the database, and manage the
pictures within the local file system.

Both methods have pros and cons.

If you store the pictures inside the database, you need to make sure
that backups are not taking compromisingly longer. Firebird 2 will
introduce incremental backups, but until then backup will have to back
everything up. You would use a BLOB field to store it, I would suggest
for jpg not to worry about compression. You will then have to trouble
the database if you want to email someone a picture, whereas if it was
in the file system, you could just go to it directly.

If you go the other way, then you need to understand that many OS have
implementation limitations on the maximum pictures per folder, where
performance starts getting really bad if you have too many more.

Once this has been decided, then either way the code is pretty simple.

Adam







++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

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" on the web.

To unsubscribe from this group, send an email to:
firebird-support-unsubscribe@yahoogroups.com

Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.


---------------------------------





---------------------------------
Yahoo! FareChase - Search multiple travel sites in one click.

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