Database size???

[Ladys]

Hello,

I am building up database, which is based on list of employees. In every record (person), there are few (20?) of fiels with text and one container with photo.

When i would like to add the photo (working on Macbook with iSight), I open up Photobooth, make photo, save the file to desktop, open it with Preview, crop it, and Copy and Paste to database. (i didn't find something else how I can grab picture directly to database with crop ability).

But: now I have 60 records (60 persons, 60 photos) in database. And the size of database is abou 30MB !!!!

Picture on desktop (before I crop it and copy/paste it) has for ex. 84KB.

When I drag and drop picture from db back to desktop, it has about 0,5MB.

Why is this happening? What can I do? I should have about 500 people in this databaese, so don't want to work with 250MB file :-(

[Fitch]

I believe FileMaker will store the picture more efficiently if you use the Insert command to put it in the field rather than Paste.

[Ladys]

Fitch, thank you so much! I tried delete all 60 pictures and add 20 with Insert Image and size of the database is 256kb now.

Thank you!!

[elanahy]

Hi I have a question on this topic. So I hope it is OK I'm going to ask it here. I’m having a file size issue in the container field. The container fields are storing the actual files (not links to the files). They are currently inserted by the user using the Insert object option. Selecting: Create from file. Selecting the file and opening it. Then clicking display as icon.

They do not want a link to the file they want the actual file but will not need to edit it. Is there any way to save it to keep the file size down? I know in FMP8.5 file size is not an issue but I would still like to save the file in the most efficient way.

Thank you for any thoughts on this.