2.02-13 Only use POST for its specific purpose
Don't use POST for simple data offsets. OFFSET, LAG or MOVINGSUM are more efficient
Tagged:
0
Comments
-
What is the reason for it?
0 -
What is the reason for what? Post can cause performance issues. If you are asking what the function is used for, you can find it Anapedia.
0 -
why post should not be used for simple data set and how does post cause performance issue?
0 -
Because it can combine the value already there or multiple cells, and due to this, it checks every cell in the timescale. It is best to use next(), movingsum(), lag(), or offset().
0
