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

calculated results/values.

I use the data for analytics.

Thanks in advance for your tips/hints.

Lawrencex

Maybe, You could use calculation as field options, not as a formula. Works the same way (will be calculated when ever one of the 'base' fields changes), but is not a formula, beside of the auto-fill-option like a text or number field (or whatever)

80 million records... will take time to process