Improve Performance and Load Time in Grids, Sections, and Tabs

There are six system parameters that determine behavior for data loading in grids on list pages and sections/tabs:

  • AA 920 - Grid Results Warning Level - Number of grid results that cause the user to receive a warning before loading.
  • AA 921 - Max Grid Results Limit - Maximum number of results a grid displays.
  • AA 922 - List Page Data Chunk Items Count - Number of results to display prior to clicking the All button in a list page.
  • AA 923 - List Page Grouped Data Chunk Items Count - Maximum number of results a grid displays if the data is grouped in a list page.
  • AA 924 - Section Data Chunk Items Count - Number of results to display prior to clicking the All button in a section/tab.
  • AA 925 - Section Grouped Data Chunk Items Count - Maximum number of results a grid will display if the data is grouped in a section/tab.

Load a Grid on a List Page

When loading a grid on a list page, Momentus follows the below logic:

  1. Does system parameter AA 921 have a value?
    • Yes – Display a warning if the returned results are greater than AA 921. Otherwise, proceed to step 2.
    • No – Display a warning if the returned results are greater than 25,000. Otherwise, proceed to step 2.
  2. Are any of the columns grouped in the view?
    • Yes - Does system parameter AA 923 have a value?
      • Yes – Display a warning if the returned results are greater than AA 923. Otherwise, proceed to step 3.
      • No – Display a warning if the returned results are greater than 1,000. Otherwise, proceed to step 3.
    • No - Proceed to step 3.
  3. Is the View configured to return all rows?
    • Yes – Load grid.
    • No - Does system parameter AA 922 have a value?
      • Yes – Load the number of records in AA 922 and display the All button.
      • No – Load 200 records and display the All button.

Load a Grid in a Section or Tab

When loading a grid in a section or tab, Momentus follows the below logic:

  1. Does system parameter AA 921 have a value?
    • Yes – Display a warning if the returned results are greater than AA 921. Otherwise, proceed to step 2.
    • No – Display a warning if the returned results are greater than 25,000. Otherwise, proceed to step 2.
  2. Are any of the columns grouped in the view?
    • Yes - Does system parameter AA 925 have a value?
      • Yes – Display a warning if the returned results are greater than AA 925. Otherwise, proceed to step 3.
      • No – Display a warning if the returned results are greater than 1,000. Otherwise, proceed to step 3.
    • No - Proceed to step 3.
  3. Is the View configured to return all rows?
    • Yes – Load grid.
    • No - Does system parameter AA 924 have a value?
      • Yes – Load the number of records in AA 924 and display the All button.
      • No – Load 200 records and display the All button.

Related articles

Comments

7 comments

Date Votes
  • Alex Zheng

    HI,

    I am wondering, how do I know " Is the View set up to return all rows" ?

    0 upvotes

  • Maggie U.

    Hi Alex,

    To see if a view is setup to return all rows, go to the screen where your view exists and select the view from the View drop-down.  Next, click on the View drop-down again and click Save View.  This will display the detail view information including a checkbox at the bottom that says "Display all rows".  If this checkbox is checked, then all rows are being displayed when the view is selected,  If the checkbox is unchecked, then only a system configured amount of rows will display when the view is used. 

    Thanks,

    Maggie

     

    0 upvotes

  • Kieron Marshall

    Is there a way like above where we can set how many contacts when setting up a service order are loaded before it is blank and shows the "Load all" option? we want to look at increasing it so that all contacts are always shown.

    0 upvotes

  • Maggie U.

    Hi Kieron,

    See if System Parameter AA 927 will help accomplish what you are looking for:

    The Amount field of this system parameter contains the maximum number of items that will appear in a static dropdown combobox.  If the number of items exceeds the amount set in this parameter, the dropdown combobox will be dynamic loading.   A static dropdown combobox loads all the items upfront.    A dynamic dropdown combobox loads items as you type search criteria.  If this system parameter's Amount field is not set or is set to an invalid value, the maximum number of items that will that will appear in a static dropdown combobox will default to 20 items.

    Thanks,

    Maggie

    0 upvotes

  • Kieron Marshall

    Thanks Maggie that is exactly what I am after.

    0 upvotes

  • Abhishek. Mathur

    Hi Maggie

    Is there a way we can determine how many users of a current view is using the option of "display all rows" on their dashboard?

    We are wanting to fine tune some performance issues.

    Regards

    Abi

    0 upvotes

  • Maggie U.

    Hi Abhishek,

    This is a difficult one to answer. I am going to give you a way to see which views are set up to “Display All Rows” that will be available in the upcoming v20.93 release. This doesn’t necessarily give you views that are performance problems because there are filters attached to views as well. So you could be displaying all rows but have filters attached that only return two rows.

    In v20.93, you can go to the Views option off the main menu and show the “Display All Rows” column. There isn’t a filter for this field but you can group on it to see which ones are set to Display All Rows by default.

    Thanks,
    Maggie

    0 upvotes

Please sign in to leave a comment.