Adagio GridView 9.3B (181107) has been released. This Upgrade offers the following improvements:

• Significant performance improvements when processing or linking to large files by building temporary indexes for Links and Filters.
• Improved handling of large, volatile files such as OEHEAD or OELINE by directly reading the data records rather than relying on an index.
• Improved calculation engine speeds the evaluation of Filters and Calculated Columns.
• Direct retrieval and storage of documents from DocStore when a View is exported to Excel with the DocLink column. Copy and paste documents from the context menu.
• Duplicate a View by pressing Ctrl-Alt-V. Drag and drop a View into a Workspace.
• Text and Date buttons have been added to the Format Toolbar.

This Upgrade should be considered by sites managing complex Views on large databases.

The increase in performance can be dramatic. When running this Workspace which looks up a set of records in a 600K file, the process went from 25 seconds to virtually instantaneous after the initial file read.

A companion release of GridView-RW is also available for download.

A minor problem has been identified in the this release.

If you have a Filter of "//" (All records), with a Sort Sequence attached to this Filter, then no records will be selected from the file. To correct the operation of the View, change the Filter to "1=1" and all the records will be selected as expected.

A Hot Fix is being prepared to address this problem.

Actually, it's any filter where all of the lines start with "//".

"//" is a handy way of telling the filter to treat what comes after it as a comment and not to process it as an instruction.

Steve

AND there must be a Sort Sequence defined as part of the Filter.

PS - the bug will be very apparent. Instead of every record being selected, no records are returned.

GridView 9.3B (2018.12.01) Hot Fix and later releases will address this.