FWD » Core Development » Database

Currently ProgressiveResults always starts with a set size of 1. This was done because the following idiom was seen:

FOR EACH something WHERE ...:
   ...
   LEAVE.
END.

// this code may also use something

The idea is that there may be code in the block to process something but that there is a LEAVE (conditional or unconditional) such that we never iterate the FOR loop. If we got all records back (or a large number), then this use case would be costly compared to the 4GL.

However, we don't know if this is generally a common use case. It was seen often in old code but how often is it really hit?

We should track (maybe with JMX?) the number of results actually used in a given ProgressiveResults query so that we can evaluate the effectiveness of this approach.