Skip to main content

Checkup Documentation

Web Parts that do not have Columns specified

cms-pagetemplate-webparts-with-columns-not-specified

severity-low

Summary

For Portal Engine sites, it is important to only return the data you need. By default, a web part for a page type will return hundreds of fields (when joined with the Tree, Document and other tables). Most of the time, your transformation is only using a few of these fields. There is no reason to bring back all that data. Even if it is being cached, there is no reason to have each cache item that large. This can significantly impact performance.


Check Logic

Constant Care for Kentico will ensure the Number of Page Templates that have WebParts that do not specify Columns is no more than 0 (default)

You can manage your settings for this checkup in the Constant Care for Kentico admin settings.


Verifying The Check

Review your webparts that have columns (typically repeaters, data sources, etc). If they do not have the "Columns" field specified, figure out what columns are acutally being used, and specify them. If using a web part that uses a query, be sure your query allows you to pass along the columns.

Kentico will help you automatically determine which fields are needed if you use their SQL Debugging tools.

Changes to your site should only be made by an experienced Kentico Xperience developer. If you need assistance in making these changes please reach out to the Toolkit For Kentico team to be connected with a Kentico Xperience partner.