With large amounts of data, some pages in administrator break

[OLamelas]

In production, with large amounts of data, producing lots of availabilities, some pages still break.

This has been identified when trying to access a layer that is used in more than 100 territories and by many users/roles. This could at the very least be improved by making each request as the user activates each of the tabs, instead of triggering all of them at once when the form is opened. This may also be related to some extent to the cartesian product identified a while back:

As of now, I haven't reproduced it nowhere else, only in layers with lots of availabilities.

[fjlopez]

Could you check the backend logs to confirm these findings?

One possible solution could also be to migrate the layer relation tables to the infinity-row model.

[fjlopez]

@OLamelas do the following test. Edit layers-form.component.html and wrap mat-card with <ng-template matTabContent>. This will implement for availabilities the solution that you proposes and help you to identify the cartesian product origin.

    <mat-tab label="{{ 'entity.cartography.territories.header' | translate }}">
      <ng-template matTabContent> <!-- wrap begin -->
      <mat-card appearance="outlined">
        <mat-card-content>
          <app-data-grid [changeHeightButton]="true"
                         [allNewElements]="isNewOrDuplicated()"
                         [columnDefs]="territoryAvailabilitiesTable.relationsColumnsDefs"
                         [getAll]='territoryAvailabilitiesTable.relationsFetchFn'
                         [eventAddItemsSubscription]='territoryAvailabilitiesTable.addCommandEvent$.asObservable()'
                         [eventGetAllRowsSubscription]='territoryAvailabilitiesTable.saveCommandEvent$.asObservable()'
                         [eventRefreshSubscription]='territoryAvailabilitiesTable.refreshCommandEvent$.asObservable()'
                         [discardChangesButton]=true
                         [redoButton]=true
                         [undoButton]=true
                         [deleteButton]=true
                         [addButton]=true
                         [hideDuplicateButton]=true
                         [hideReplaceButton]=true
                         [defaultColumnSorting]='territoryAvailabilitiesTable.defaultRelationsSorting()'
                         (getAllRows)="territoryAvailabilitiesTable.handleSaveRelations($event)"
                         [actionButton]=true
                         (add)="territoryAvailabilitiesTable.openDialog($event)"
                         *ngIf="dataLoaded"
          >
          </app-data-grid>
        </mat-card-content>
      </mat-card>
      </ng-template> <!-- wrap end -->
    </mat-tab>

[fjlopez]

Validation update (PARTIAL): backend cartesian on Cartography.findById addressed via @batchsize (backend CHANGELOG cites #41). Admin layers form still registers relation tables eagerly (layers-form.component.ts dataTables.register) — keep open until fat-layer admin load is re-verified / lazy tabs considered.