By default, whenever the SQL Repository calls getItem, it loads from the database (or the cache) not just the repository ID of the item, but all repository item properties that are stored in the primary database table for that item’s item descriptor. For some applications, this may result in too much database activity. For other applications, you may want to load repository item properties that appear on other tables. You can adjust how the SQL Repository loads repository item properties by grouping properties, using the group attribute in property tags in the repository definition file. All properties with the same group attribute are loaded whenever one property of the group is loaded. For more information, see the ATG Repository Guide.
