Similar Databases with Drastically Different File Sizes
I am working on some database files for an engineering firm using FileMaker Pro 7 (old, I know, but it's what they have and what they want to use). Most of the databases are quite similar in terms of their layouts and their fields, but the file sizes for the databases are all over the place and do not correspond to the number of records in the databases.
For example, one database has nearly 3500 records with a file size of only 2 MB. But a different database that has less than 200 records has a file size of nearly 50 MB. I cannot seem to find the reason for the vast disparity in the file sizes.
If more information is needed, please do not hesitate to ask and I'll supply what I can. As a heads-up, I am not a database expert and have no formal training at all. I've picked up what I've needed to do my job and that's it.