Nevron Vision for SQL Server Reporting Services
Resources and Articles / Performance Tuning
In This Topic
    Performance Tuning
    In This Topic

    This article provides some performance optimization tips that can help in cases you need to get optimal performance from control. The discussion applies to both Nevron Chart for SSRS and Nevron Gauge for SSRS.

    The SSRS report item processing internally goes trough the following stages:

    1. Data Collection - at this stage the control reads its rdl definition.

    2. Configuration - at this stage the processes the rdl definition and produces a chart or gauge document.

    3. Image Rendering - at this stage the control renders the generated document to a raster image (BMP, PNG etc.) as specified.

    4. Image Map Generation - this is an optional rendering pass which generates an image map on top of the generated image raster (stage 3).

    You can track the performance of each stage by checking the "Display Statistics" check box in the Rendering\Statistics tab. In general you affect the Data Collection / Configuration stages time when you design the template, so you do not have a direct way to optimize these stages. There are settings for stages 3 and 4 however that can significantly improve the performance.

    General Rendering Optimizations

    You can consider to modify the following settings in order to optimize stages 3 and 4:

    Name Location Description
    2D Antialiasing Rendering \ Quality Turns on or off the antialiasing of 2D fill and stroke borders. Used in 2D and 3D charts. Enabled by default. For optimal performance you should turn off 2D Antialiasing.
    3D Antialiasing Rendering \ Quality Turns on or off the antialiasing of 3D fill and stroke borders. Used in 3D charts only. Enabled by default. For optimal performance you should turn off 3D Antialiasing.
    Antialiasing Samples Rendering \ Quality Specifies the number of antialiasing samples, regarded only when 3D Antialiasing is enabled. For optimal performance you should decrease the number of samples (in case you use 3D antialiasing).
    Text Rendering Mode Rendering \ Quality Specifies the text rendering mode. Set to "Clear Type" by default. For optimal performance you should use Aliased rendering.
    Enable XML Text Formatting Rendering \ Image Whether to allow XML formatted texts for titles, data labels, legend data items etc. For optimal performance you should disable XML Text formatting, in case you do not use XML formatting features.
    Render Image Map Rendering \ Image Whether the control should generate an image map. Enabled by default. For optimal performance you should off this option in case you do not use chart or gauge element actions (drill trough, URL link etc.).
    Light Model Chart Areas \ 2D/3D Effects Specifies the light model applied on 3D charts. For optimal performance you should select "None" from the available options.

    Other Considerations

    Shapes - Bar, Pie, Point, Bubble etc. charting types allow you to select a data point shape. Some shapes are more expensive to render than others. Consider using simpler shapes especially when you have many data points.

    Shadows - soft shadows like (Gaussian and Linear) are expensive - consider using solid shadows or turn off shadows.

    Image Filters - consider not to use image filters.