Web parts that do not have columns specified
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.
Constant Care for Kentico will ensure the Number of page templates that have web parts 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.
Review your web parts 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.
Not sure what to do?
If you are ever unsure about making changes to your site, we encourage you to reach out to your
Kentico Xperience Gold Partner. If you do not have a partner,
then feel free contact the Constant Care For Kentico team to get connected
with an expert