Online Help | Desktop App

Improving view performance

Views with a large number of records may affect the performance, especially when the database connection is slow. For better performance, reduce the number of records in the view. This page describes the ways how to do and gives you other suggestions.

TIP: Performance heavily depends on your environment. You may want to change the default limit of records to retrieve in your personal settings. For details, see Limiting the number of records to retrieve.

  • Apply advanced filter

    Advanced filter is a permanent solution to show only what you want to see, reducing the number of records in a view and improving its performance.

    To apply an advanced filter, right-click anywhere in the grid and choose Customize View from the context menu. In the Customize View dialog box, go to the Advanced Filter tab and create your filter. You can filter by any fields, including shown in the view and hidden ones. Create your filter with an intuitive graphical editor (as shown in the example below) or switch to the SQL mode and specify a SQL WHERE clause.

    Then save the view to save your changes. For shared views, you may need to save your customized view as a local copy.

    INFO: For detailed instructions on how to use the advanced filter, see Advanced filtering in data grids.

  • Close unneeded tabs

    It might sound obvious, but yes —close any Alloy Navigator tabs not being used.

  • Reduce the number of retrieved records and show selection dialogs initially empty

    Reducing the number of records that your Alloy Navigator retrieves from the database at a time may help improve the performance. However, the retrieved records may be not the ones you expect to see. That's why you may want to use this method in a combination with the advanced filter.

    To reduce the number of retrieved records, select Tools > Options from the main menu. In the Options dialog box, go to the Advanced tab and enter a lower number in the Limit number of records retrieved from the database to field. Clearing the Always prepopulate object selection dialogs with data check box also helps improve the performance.

    INFO: For detailed instructions, see Applying advanced preferences.