Container Fields = Huge

[Ben Ball]

Hi all, I am having problems with inserting pictures into my database. I am sure I am doing something wrong as the database is getting huge.

I am inserting .jpg files from a photo file. Directly, by a right click of my mouse (in the container field) then finding the file from its location.

I thought by doing that it would actually still be storing the memory in its contained folder and not in the database?? Am I talking Sh*te?

Is there a way to store the pictures in a better way. The way I am doing it is a nightmare and making the database processing extremely slow...

[glenhest53]

Hi Ben:

Click the checkbox "Store only a reference to the file" when importing the images.

The downside: if you move the folder where the images where imported from or delete, rename any of the image files then the reference will be broken.

But it does make for a smaller database size.

[Ben Ball]

Thanks for pointing that out. Easy when you know how..