Performance Tips and Tricks
RadSpreadProcessing allows you to prepare and modify tabular data. Even though the library was built with performance in mind, working with large amounts of data slows it down. The following tips help you get the most from the component in terms of performance.
Reduce Layout Updates Frequency
Calculating the layout is an operation that computes the width of each column, the height of each row, the size of the text contained in the cells, and many other elements used for positioning the UI. The layout update triggers each time a property changes and is a fairly heavy operation.
Internally there are many mechanisms used to lower the number of calculations, but sometimes they are not enough. For example, if you want to generate a document and then show it, you do not need to trigger any layout updates other than the one after you finish creating the document. The following code snippet shows how to suspend and then resume layout updates after document generation is completed.
Example 1: Suspend Layout Updates
Workbook workbook = new Workbook();
workbook.SuspendLayoutUpdate();
//The code which generates the document
workbook.ResumeLayoutUpdate();If an exception is thrown between the two method calls, the resuming of the layout update will not execute and the UI will stop updating. You can ensure the layout update resumes regardless of exceptions by using UpdateScope. The following code snippet demonstrates how to use it.
Example 2: Suspend Layout Updates in UpdateScope
Workbook workbook = new Workbook();
using (new UpdateScope(workbook.SuspendLayoutUpdate, workbook.ResumeLayoutUpdate))
{
//The code which generates the document
}Reduce the Number of Undo Steps
Preserving information about the steps in the undo stack is usually not a time consuming operation, but even the lightest operation performed thousands of times may slow down your application. If you do not need to preserve each step in the document generation process as a separate undo step, you can combine a series of actions into one undo step. For example, if you want to set background color to the even rows in your table, you have to set the fill for each row separately. This way each background setting is preserved as a separate undo step. To combine them in a single undo step, use the following code.
Example 3: Combine Steps in Undo Group
Workbook workbook = new Workbook();
workbook.History.BeginUndoGroup();
//The code which generates the document
workbook.History.EndUndoGroup();If an exception is thrown between the two method calls, the ending of the undo group will not execute. All the following actions will not be added to the history and the UI will stop updating. You can ensure the undo group closes regardless of exceptions by using UpdateScope. The following code snippet demonstrates how to use it.
Example 4: Combine Steps in Undo Group Using UpdateScope
Workbook workbook = new Workbook();
using (new UpdateScope(workbook.History.BeginUndoGroup, workbook.History.EndUndoGroup))
{
//The code which generates the document
}Disabling History
As described in the Reduce the Number of Undo Steps section, preserving the history steps can lower the performance of RadSpreadProcessing. If you do not want to preserve History while generating your document, you can turn the feature off. Switch it on and off through the IsEnabled Boolean property of the history as shown in the following example.
Example 5: Disable History
workbook.History.IsEnabled = false;
//The code which generates the document
workbook.History.IsEnabled = true;If an exception is thrown before enabling the history, it will not be enabled and the subsequent history steps will not be preserved. To ensure that the history is enabled, use the UpdateScope class. The following example shows how to achieve this.
Example 6: Disable and Enable History Using UpdateScope
using (new UpdateScope(
() => { workbook.History.IsEnabled = false; },
() => { workbook.History.IsEnabled = true; }))
{
//The code which generates the document
}Apply Values or Formatting on Large Range at Once
Setting the same values to thousands of cells one by one takes more time than setting the same values to an entire cell range. Create a CellRange using the row and column indices of the start and end cells.
public CellRange(int fromRowIndex, int fromColumnIndex, int toRowIndex, int toColumnIndex)
Avoid Using the Additional Calculations Options Provided by the Shapes and Images
When setting the properties of an image you have created, keep in mind that some of the members may cause recalculation of other properties to make the images more convenient to use in a UI context. You can read more about what calculations are performed in the Shapes and Images article. If you are generating a document from scratch, the recalculation of other properties will most likely be an unnecessary burden for your application. In this case, use the properties of the shape classes:
-
Width -
Height -
RotationAngle
Avoid using the methods for setting the same properties with the adjustCellIndex parameter set to true:
-
SetWidth() -
SetHeight() -
SetRotationAngle()
Avoid Cell Value Type Parsing
When setting values to cells, the cell value type is determined by an internal parsing mechanism. If you are sure what cell value type the passed value must produce, set it specifically. This bypasses the parsing and increases the performance of the application.
The easiest way to achieve this is by using the SetValue() overload with the respective CLR type (DateTime, Double, and others) or in the case of formula value type and text value type, the SetValueAsFormula() and SetValueAsText() methods respectively.
More information about cell value types is available in the Cell Value Types article.