Decimal Precision Performance Impact
Summary
Increased Consolidation Times with Custom Decimal PrecisionContent
Wondering if anyone else has performed regression testing on the DecimalPrecision substitution variable? We were experiencing elimination issues due to the decimal precision. I created the variable and initially set the value to 6. I ran monthly consolidations for 3 years. We still found data points going out to 9 or 10 decimal places. So I changed the value to 12 and have again re-run 3 years of consolidations. After each year, I restructured and cleared empty blocks. Typically we do this each month in Prod, but doing so was not practical for this exercise.
I am noticing consolidation times between 50-75% higher with the 12 vs out of box value of 4. I would say that it might not be completely apples to apples as I am testing in a random Pod, not our normal testing pod as we currently have connection issues and are running different patch levels.