Projects:Prevent Unneeded Grid Requests&action/Performance-Testing

Contents 1 Comparison of the number of datasource requests 1.1 In Sales Order, in a scrolled grid, with no record selected 1.2 In Sales Order, in a scrolled grid, with a record selected, in grid view 1.3 In Sales Order, in a scrolled grid, with a record selected, in form view 1.4 In Sales Order, in a scrolled grid, with a record selected, after processing an order in form view 1.5 In Sales Order, in a scrolled grid, with a record selected, after processing an order (manual process) in form view 1.6 In Payment In, in a scrolled grid, with a record selected, after adding details to a record (standard view) in form view 2 Comparison in CI

Comparison of the number of datasource requests

More detailed information can be found in this spreadsheet

In Sales Order, in a scrolled grid, with no record selected

Before: 2 datasource requests to refresh the whole grid. After: 1 datasource request to refresh the whole grid

In Sales Order, in a scrolled grid, with a record selected, in grid view

Before: 2 datasource requests to refresh the whole Order grid, 3 datasource request to refresh the whold Order Line grid

After: 1 datasource request to refresh the whole Order grid, 1 datasource request to refresh the whole Order Line grid

In Sales Order, in a scrolled grid, with a record selected, in form view

Before: 3/4 datasource request to the Order datasource, 2/3 of them with targetRecordId which result in very slow queries. 1/2 request to load the Order Line tab

After: 1 datasource request to refresh just the selected Order, 1 datasource request to refresh the whole Order Line grid

In Sales Order, in a scrolled grid, with a record selected, after processing an order in form view

Before: 4 request to the Order datasource. 3 to load the selected record, one to load the grid with targetRecordId. 2 datasource requests to load the Order Line tab

After: 1 datasource request to refresh just the selected Order, 1 datasource request to refresh the whole Order Line grid

In Sales Order, in a scrolled grid, with a record selected, after processing an order (manual process) in form view

Before: 4 request to the Order datasource. 3 to load the selected record, one to load the grid with targetRecordId. 2 datasource requests to load the Order Line tab

After: 1 datasource request to refresh just the selected Order, 1 datasource request to refresh the whole Order Line grid

In Payment In, in a scrolled grid, with a record selected, after adding details to a record (standard view) in form view

Before: 4 request to the Order datasource. 3 to load the selected record, one to load the grid with targetRecordId. 1 datasource requests to load the Order Line tab

After: 1 datasource request to refresh just the selected Order, 1 datasource request to refresh the whole Order Line grid

Comparison in CI

Number of the request to Datasource executed to complete CI flow decreased from 3927 to 2653, this is 20% less of number of requests.