Dear FileMaker Pros,
Would appreciate your tips/hints for the following:
My database created in FileMaker 15 (Win 10) has more than 100 Fields,
and over 80 million records in each Fields. The file size is approximately
2.5 GB. Those Fields contain calculations.
I am NOT using scripts for the calculations as it consumes so much of
time processing the entire records (takes 8 hrs.)
So, when the calculations are complete, I export the Field data to a
new .fmp12 file, so that the data becomes "flat" without any calculations.
The problem again, the export process is time consuming, and it almost
takes the same time as running the scripts for the calculations.
Would appreciate your tips/hints, if there is a way to save the .fmp12 file
as a "flat" file, meaning, saving the file/data without the calculations, but
the calculated values only. For example, in MS Excel, this is achieved by
the "paste as value" options, and the calculations are pasted over with the
I use the data for analytics.
Thanks in advance for your tips/hints.