Support Article

Delay of a minute occurs while adding a row in repeating grid

SA-59780

Summary

There is a repeating grid which contains three columns.
First column is populated by a drop down which is populated using a node level data page.

After adding 10 rows, when the user attempts to add another row, a delay of about a minute occurs.

Error Messages

Message from webpage:

There was an error when loading the content given.
IE Error description: Not enough storage is available to complete this operation.

Steps to Reproduce

Create a repeating grid
Populate the first column dropdown using a data page containing 10000 records
Attempt to add more than twenty records. Add a record by clicking the Add button

Root Cause

A dropdown control is not recommended when there is a large number of options. The grid is set to always editable, meaning that for every row there is a dropdown containing 10,000 items. This consumes large amount of space and the browser runs out of memory.

Resolution

Perform the following local-change: Set the grid Inline edit mode to 'Click row to edit' instead of 'Rows always editable'.

Alternatively, use an Autocomplete control instead of a dropdown.
Use the 'Match start of string' configuration option to set the minimum number of characters to search for, and to only match the start of the string rather than using 'contains'.