My advice is to store image files in your file system and then just store
file names in the database.

That's how we do it. Files are much easier to manage than blobs.
Especially when you are trying to have a backup on a regular basis. Blob's
don't have archive bits.

Regards,
Jason

> -----Original Message-----
> From: IBObjects@yahoogroups.com [mailto:IBObjects@yahoogroups.com]On
> Behalf Of Enrico Cima
> Sent: Monday, January 08, 2007 3:07 PM
> To: IBObjects@yahoogroups.com
> Subject: [IBO] Same database file or different database files
>
>
> Dear Group,
>
> I would like to add A4 scans photo for a collection in the Database.
>
> Q1: I have already a database around 1,3 GB. Since the photo
> database will not need to have any join query with the main
> database, i was thinking to take them separately, so not to
> make heavy the main one. Does it make sense? Or even the Main
> database is growing the speed of the main database access
> will not degrade ? And what will happen after 2GB ?
> Q2: is there a free component like IB_Image that is already
> compressing the image and working with JPG files?
>
> Thanks to all.
>
> Kind Regards
>
> Enrico