5 Replies Latest reply on Mar 31, 2009 7:34 AM by TSGal

    Optimize and compress a database

    derbgl

      Title

      Optimize and compress a database

      Post

      In FMP Advanced 9 I could compress and optimize a database from the tools menu.  I do not see that in FM10.  Is the Save as & compress the only way to do that now or has the comand been moved?

        • 1. Re: Optimize and compress a database
          TSGal

          derbgl:

           

          Thank you for your post.

           

          In FileMaker Pro 10, you still have the same options for saving a compress/smaller copy.  Pull down the File menu and select "Save a Copy As..."  There will be three options under type: "copy of current file", "compacted copy (smaller)" and "clone (no records).  The compacted copy does compress the file and removes any extra space.

           

          TSGal

          FileMaker, Inc. 

          • 2. Re: Optimize and compress a database
            ralvy
               I saving a database file as Compressed supposed to be as safe as saving it as a Copy of the Original, or is there some small risk in compressing that isn't present when doing a straight copy.
            • 3. Re: Optimize and compress a database
              TSGal

              ralvy:

               

              When you save a database file as compressed, it removes any extra space that is generally used for adding records and updating indices.  Therefore, if you add records later, you will notice FileMaker Pro acting a little slower because it now has to make room for new data.  So, if you don't plan to add any more records to the table, compressing the file will be better.

               

              TSGal

              FileMaker, Inc. 

              • 4. Re: Optimize and compress a database
                ralvy
                  

                TSGal wrote:

                ralvy:

                 

                When you save a database file as compressed, it removes any extra space that is generally used for adding records and updating indices.  Therefore, if you add records later, you will notice FileMaker Pro acting a little slower because it now has to make room for new data.  So, if you don't plan to add any more records to the table, compressing the file will be better.

                 

                TSGal

                FileMaker, Inc. 


                Well, is it slower adding records for a while, but gets back up to speed once there are old records there?


                • 5. Re: Optimize and compress a database
                  TSGal

                  ralvy:

                   

                  Yes, it is slower for awhile, but once room is made for the data and indices, it should perform at normal speed in a short time.

                   

                  TSGal

                  FileMaker, Inc.