Jump to content

Reducing database file size by store container fields externally


This topic is 3048 days old. Please don't post here. Open a new topic instead.

Recommended Posts

Good day all,

 

I have a monster 25 GB Filemaker database file hosted by Filemaker server. The file already started to perform slow. I recently set storage option of all container fields to "Open Storage". All photos from container fields are now stored on a local hard drive of my server computer. But the database file size is still the same, not even 1 byte smaller. Any thoughts?

 

Is there any other ways of file size reducing?

 

Regards,

Link to comment
Share on other sites

Take the file down and run the "save as - compacted" as a first step

Wim,

 

Thank you so much for your prompt reply, I followed your suggestion and now it is very much smaller.

I wonder what happens now if I deploy this copy again in my Filemaker server, and let users to add data to this file? Should I take the file down, save a copy as compacted, then deploy it again every now and then? Or it will not store the images in container fields from now on?

 

Thanks you!

Link to comment
Share on other sites

If you have set the container settings correctly it will now store all container data remotely and not increase your file size.  Doing a "save as compact" is good periodic maintenance ( every month, a few times per year,...) as it reclaims empty space and reorders the logical internal blocks.

  • Like 1
Link to comment
Share on other sites

If you have set the container settings correctly it will now store all container data remotely and not increase your file size.  Doing a "save as compact" is good periodic maintenance ( every month, a few times per year,...) as it reclaims empty space and reorders the logical internal blocks.

Thank you so much.

Link to comment
Share on other sites

This topic is 3048 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.