Jump to content

FM7 file size getting smaller


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

Recommended Posts

Hi,

 

This looks strange to me last day when I found that our backup copy size just getting smaller recently.

 

We host our databases using FMS 9 and schedule daily backup at non-peak hour over the night.

 

One of the database file size is pretty large, which overs 2.5G in size. Our usual backup practice is to use FMS to run scheduled backup task and run script to zip the backup copy to a zipped file and copy it to an remote storage using some simple OS script.

 

I found that the zip file size is reducing quite a lot recently, say from 1.92G to 1.86G. I thought my users must have deleted records with container fields content. After checking around, they said no major records deletion be carried in last few days and I actually found the number of records is increasing.

 

So, would someone here can give me some light on what can this be? Would FMS do database optimization itself when file growing to certain size. This is the first time I aware such behavior. 

 

Or would someone suggest the step that can help to reconcile if the data in the file is intact.

 

 

 

Thanks.

 

Regards,

Oliver

Link to post
Share on other sites

I have never know Filemaker to optimize by itself.

Things that can effect it are not just the data but the calculations can effect it as well, have you made any changes to any of the calculations? or relationships ?

Check the pre-zip size to see if it is correct. could be an update effecting how it zips

if not, then I would take an old backup  that was 2.5 gig, export to a text file, then export from the new file  and compare the 2 either manually or with software to compare text files.

We can go from their if the answer does not show itself

Link to post
Share on other sites

For my case, it's actually the fp7 file. That's what worrying me a bit.

 

It's quite a big job or a tedious work for a big file with lots of tables without some automation tools. I will go from there and see if any findings pop up. 

 

You suggestion is  much appreciated.

Link to post
Share on other sites

I finally found out the cause is container field related. One day, my users had uploaded some very big images to the container fields and just put in another set of much smaller image recently. This contributed to the size reduction of the fm7 file. 

 

Wow.... it's something not that easy to dig out in direct. Fm7 file format does not allow limiting the container field size in use which can make file size very large in size.

 

Any ideas on how to fine tuning this limitation? Or has this be addressed in FM12?

 

Thanks.

Link to post
Share on other sites

FM12 and FMS12 support 'Remote Containers'

 

This can significantly reduce the file 'bloat' you can get with internally stored containers.

 

Have a look at the FM web site for documentation.

Link to post
Share on other sites

This topic is 2499 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
  • Similar Content

    • By Rich
      Greets, and a happy, holiday season to all.
      This is one of those "Well, I could swear it _used_ to work..." FMP (PC) problems: I want a script to create a custom-named folder on the desktop (PC) [for exporting data purposes] so I used the following (see attached) Send Event command: 
      "cmd /c md " & Quote ( Right ( Get ( DesktopPath ) ; Length ( Get ( DesktopPath ) ) -1 ) & "Job Chop-Chop! Backup" )
      ...in earlier versions of FMP--and if memory serves--it used to work. (See https://fmrift.wordpress.com/2010/02/03/creating-a-folder-from-filemaker-windows/ ). However, when I try to run the script in FMP v17.x the script fails with the following error message in the Script Debugger, "[3] Command is unavailable (for example, wrong operating system or mode)".
      So, I'm trying to figure out why the command's failing--could it possibly be it's because I'm using FMP (PC) in VMWare's Fusion PC emulator (v10.1.4, running in OS Mojave) instead of on a "real" PC? Any ideas for a tweak/fix?
      Cheers,
      Rich

    • By jrich4411
      Good evening people.  As the title states, I am a complete newbie to FileMaker Pro.  I've done some fairly extensive work with Excel, but this is my first experience with databases.
      For now, I'm looking for advice and suggestions.  I promise I will have plenty of "how do I... " questions later, but for now I need to pick a direction to go in with my new project.  I've spent a bunch of hours viewing Intro to FileMaker tutorials on YouTube and I've experimented with creating a couple test databases.  If this is not the correct forum for this question, please let me know.
      So, my wife and daughter are heavily involved with riding horses.  I've been drafted into being on the Board of Directors for our state Quarter Horse Association (Quarter Horse is a breed like Thoroughbred or Clydesdale).   The first thing I discovered is that they have NO association membership database of any sort.   What they do have is simply a file folder of applications for members, one folder for each year.  Me being an I.T. geek by trade, I know there is a better way.  I've at least entered the info into a spreadsheet (my specialty) so we have the info electronically to be able to reference current membership status during our shows.
      I wish to create a database for the membership, which I've done so far.  It has basic info - name, address, etc.  I have an ID field that automatically increments with each record - seems to be a strong recommendation in the tutorials I watched.  I have a field that combines the first & last name fields which I plan on using for looking up membership info, sending renewals, etc later.  I also have a membership year field and here comes my first question.  When I renew a member for the new year, I want to keep the previous year's record in the database - should I ever want to print a report for 2016 membership in 2019 for instance, I can.  So I figure I need a static member ID field that is separate from the record ID field I already have that can be linked to another database which will hold that member's horse information.   Is it possible to have a field that will increment serially when I add a new member but will copy from the previous year's info when I renew a member for a new year?  
      I'm looking for any and all suggestions - links to videos that might help - suggestions for a better way of accomplishing my goal, anything at all.   I'm not a programmer so I don't have that background FYI.
      Thanks!
       
      Jon
    • By vincenzo
      Hello, I am using l am filemaker 15 pro advanced in windows 10 computer (64 bit, 8gb ram).  I buy it few week ago and i converted my database from the old version fm5. The database work properly but it is very slow to open, about 60 second or more. I am working as standalone (no remote connection). I noted thta if the PC is offline (no network or internet connection) the database open in less that 6 second. It is very strange because I have not any ip configuration and any sharing option... what can be the problem?
      Thank you in advance
      Vincenzo
    • By Nestor
      Hi,  I'm importing records and have a date field that i need to use to set my Fiscal year, month, week based on the fiscal year starting February 1st and ending January 31st.
      Any ideas or sample i might be able to take a look.

      Thanks in advance.
       
    • By Joost Miltenburg
      LS,
      We recently migrated from FM14 to FM15 and suddenly some invoices come out strange after the saveAsPdf script step . ( see pic ). When in preview mode everything  seems to be ok and is printed to a printer ok.
      Theme : Classic, Font used : Calibri size 11 and 12.
      Problem occurs on Mac 10.11 and Win10 with FM15.
      When I do a print ( to preview ( mac )) and then save as pdf everything is also ok, so it seems to be related to the FM pdf renderer.
      However, not every invoice has this issue, but I wonder how data could cause this behaviour.
      Best regards !

  • Who Viewed the Topic


×
×
  • Create New...

Important Information

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