"No Holding Back FileMaker Blogging"


Navigation:


Support this site by clicking on a sponsor below or becoming a patron!



Create a FileMaker Calendar



Become a patron of this FREE web site!


Recent Blogs:

Merging Duplicates
Merging Duplicates

Twenty Nineteen in Review
Twenty Nineteen in Review

Preventing Duplicates
Preventing Duplicates

Deleting Duplicates
Deleting Duplicates

The Downside of Indexing
The Downside of Indexing




Document Management Videos


Quick Tip:

File Maintenance
FileMaker has three methods for optimizing files. The Save A Copy As feature is available in FileMaker Pro, Developer and Advanced. This feature allows you to save a compacted copy but not like WinZip or Stuffit. A compacted copy is a duplication of the file compacted and optimized. FileMaker stores data in blocks and, when information is deleted, those blocks may become partially full. Compacting a file merges partial blocks, so there are fewer and fuller blocks -- thus creating a smaller file. Optimizing a file is a lot like optimizing your hard drive. Blocks are swapped so that data in records are grouped together. Scripts, Fields and other areas of FileMaker are also optimized to increase performance by allowing similar data to be accessed sequentially. The File Maintenance feature in FileMaker Developer 7 and FileMaker 8 Advanced simply splits these two tasks into separate features. The big difference is that the File Maintenance feature works on the current file, so you don't have to swap out the old copy for the new one.



Create a Password Management solution!


Fun Stuff:

Claris and FileMaker CEOs
Bill Campbell  1987 to 1995
Guerrino De Luca  1995 to 1997
Dominique Goupil  1997 to 2019
Grad Freitag  2019 to 2019



Create a Complete Contact Manager







RSS Feed
Subscribe to Newsletter

The newsletter is a simple HTML email informing you about the newest blog article. Email frequency is approximately 2 to 4 per month.

First Name:
Last Name:
Email: