Variable adxftl is used to set a read grouping factor in number of records. This information will be used by instruction For, so as to optimize the engine response time.
Variable adxftl is used to set a read grouping factor in number of records. This information will be used by instruction For, so as to optimize the engine response time.
When this value is lower or equal to 1, instruction For works without grouping.
When this value is greater than 1, instruction For carries out a record grouping according to the number included in variable adxftl and, then, proceeds to reading these records in the database.
Value 10 is recommended for a good read-grouping management.
When a read loop is carried out, together with record-grouping, it reduces the number of back and forth movements between the database and the engine. To keep the benefit of said optimization, and if possible, do not carry out reads through a Read in loop For. To avoid that, you should favor reads on joins resulting from links and should prefer strict joins (operator~=).
The engine does not carry out any read optimizing on tables including Clobs or Blobs.
The Choose and Fillbox instructions are not concerned by the adxftl variable, because they carry out a line grouping anyway.