The global Search form is slow to load when looking for GRNs

Owned by Beth Blok (Unlicensed)
Last updated: Nov 21, 2022 by Mike SheenVersion comment
1 min read

Problem

The global search form can take awhile to load in large databases.  

Solution

The data the global search form accesses is controlled by the Search Item Maintenance form.  And each option in the form is a stored procedure.  You can limit the data that form accesses by disabling unwanted options.

The following example limits the global search to sales orders, purchase orders and Goods Received Notes.

  1. System Settings > Search > Search Item Maintenance

  2. Un-ticked and Enabled check box for all lines except sales orders, purchase orders and Goods Received Notes

  3. Save changes

  4. Load the Search form and only records form these forms are displayed