I am working on a photo database and was wondering if the size of the image impacts the database. I am using the original images as the source for the thumbnail (usually 1600x1200). If file size makes FM slow down, then I will just convert all of the images to smaller jpgs and link to the original image on CD. If I convert the images down to about 2-3 inch thumbs of about 5k each, would that speed FM up?

The major question is: are you storing an image or just a REFERENCE to an image. If you are storing images, you database will grow significantly with many images. If you store a reference to the image, the database will not change significantly beyond the normal growth with the addition of your other record data.

-bd

I was storing an actual image....this was my reason for asking if I just make a small thumnail, would FM run better and faster....each image would never be over 5k....where as of now they are each about 300k

I'm not 100% sure, but I believe the source file size should determine the amount of storage FM needs to store the image. It's an easy experiment with the same image in two sizes and a demo file with one container field. Check the file size, import the small image, check the file size, import the large image, and check the file size.

-bd