Web parts that do not have columns specified
severity-low
cms-pagetemplate-webparts-with-columns-not-specified
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 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.
Resolution
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.