I recently split off a group of users from my filemaker database into a separate file and deleted a large number of project records. I expected the file size to decrease dramatically but it only did moderately.
To provide further specifics, the original file was about 3.3 gigs. After eliminating around 4,800 project records (and many many thousand more related records), the file had only a few hundred project records (and maybe a few thousand related records) but only reduced to 2.2 gigs. I can say confidently there are no large files stored in containers remaining.
Why wouldn't the file size have been reduced more?