PreviousNext
Help > Development > Accessing AS/400 data > Native Access > Performances > File tables with links.
File tables with links.

If a window displays a file with links, WinDev will run a « Read by key » for each linked field in each record in the table.
This will result in a large number of access to the AS/400, and the cache will not be used, because WinDev reads one record at a time.

To optimise this feature, we suggest two ways:

     Use SELECT statement with INNER JOIN clause.

     Create a logical join file on AS/400, import it in the analysis, and use it to fill up the table