Jump to content
Sign in to follow this  
Cassetti

FM 8 Database Filesize Issues

Recommended Posts

Hey everyone, got a bit of a quandary in our database that i can't quite solve. We are running some legacy databases from the days of FMP7, upgraded to FMP 8 (clients and servers).

We have around 5 database files all linked together and related to each other for the various departments of our company. Its a rather small database, only about 15 people using it.

All of our database files are roughly 100 to 200 megabytes in size, Minus one database. Funny thing is it is not the most complex and largest database that we have in terms of records/relationships/fields/tables, etc.

However it is growing quite large: 1.8 gigabytes currently!!

Previously we encountered this problem in the database, and traced it back to a container field used to store PDF files of quotes. We removed that and the problem went away.

I have already done this with the database file - I am linking to the PDF files instead of containing them in the database. I also have turned off indexing on many fields used for one table that had 32,000 records.

None of this has affected the size of the file!

How can i shrink the size of the database? It is getting to be a big stress for me in the event our server crashes (hasn't recently) we could be down for over an hour while the thing re-checks all the database files!

Thanks in advance!

Share this post


Link to post
Share on other sites

After you convert the stored container fields into referenced container fields, try saving a copy as compact.

Share this post


Link to post
Share on other sites

Question - Since I'm not the admin when it comes to the FMP server.

If we save a copy and compact it,

Will that break all relationships with the other database files that we use? Every database file has numerous relationships to tables on other files, and scripts set to go to related records on other layouts

not to mention that we also have a slew of calculated fields in other records that check related fields in the affected database.

Share this post


Link to post
Share on other sites

Really, so I won't have to do 10 or 20 hours of work to fix the relationships?!

Thanks

Edited by Guest

Share this post


Link to post
Share on other sites

When you go under file and 'Save a Copy As', a dialog will pop up with the file name +Copy as well as the option to choose Copy of current, Clone or Compacted. Choose Compacted. Your original will still be the same but your new copy should be smaller.

Share this post


Link to post
Share on other sites

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
Sign in to follow this  

  • Who Viewed the Topic

    1 member has viewed this topic:
    _ian 
×

Important Information

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