Jump to content

Is there an optimum size of the db


 Share

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

Recommended Posts

I'm very new to Filemaker, I have at my company several large datbases. Some of them have increased to 10gb in size as we are scanning a lot of information for past employee files.

I have noticed that these files are getting corrupt often and I have to restore from backup. The problem being is that I don't know when they became corupt. I have tried to rebuild the db through filemaker which takes a long time and says that it is too corrupt to rebuild.

Should I not be using FM with such large files. I'm trying to convnince my employer that we should just use folders withing Windows instead.

Any help or information regarding file limitations is greatly appreciated.

Link to comment
Share on other sites

With files embedded into FM, it may be beneficial to reference the file rather than store the actual file in the container field. It should dramatically drop the size.

Link to comment
Share on other sites

Yes, it will reference the file that you insert into the container field.

There is a drawback to this of course. If the file is moved, then the file reference path will no longer be valid of course. However, if the files are on a common network drive that everyone can access, then its fine.

If you have the budget, you may want to check out a plugin such as Troi File plugin. Its a very useful plugin to have because you can script it so that even if the file is local, it can copy it to a cetain network path and then reference that new path in the container field, so that all the files are in one central files area or server.

Link to comment
Share on other sites

This topic is 5759 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
 Share

×
×
  • Create New...

Important Information

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