FAQ's - APPX Software, Inc. : APPX Utility : APPX Development Environment : Data Dictionary :
How many times does Post-PCF Read FLEP fire?
|I have an update/query combination in a job. While stepping thru the code, I noticed that APPX ran thru the Post PCF Read FLEP 4 times for the first record (it may do it for every record, but my test only had one record in it).
Is there some reason for this?
|A range start happens when you've sorted the PCF and Appx finds a new value in one of the sort keys.
Just because you don't have a frame that executes at that range boundary
doesn't mean that the range doesn't exist.|
In other words, we detect the range start and range end boundaries regardless of whether your have range start and range end frames. Remember, you can use the same query invocation with multiple outputs.
If you remove all of the sorts, you'll still see two extra Post PCF Reads (for the unbounded range).
Appx isn't physically reading the record for each range boundary - it's just reporting the state change (by invoking the Post PCF Read).
|[Append to This Answer]|
|Previous:||Can I pass information into a FLEP?|
|Next:||Do many duplicate keys decrease the performance?|