---
title: "Why is my cohesion_layout_revision table so large?"
date: "2021-04-27T15:18:36+00:00"
summary: "Discover why your cohesion_layout_revision table is growing and learn how to manage it effectively. Understand the relationship between node revisions and layout revisions, and explore solutions for optimizing your Drupal site's database performance."
image:
type: "article"
url: "/drupal-starter-kits/add-ons/site-studio/help/65411-why-my-cohesionlayoutrevision-table-so-large"
id: "d1d98289-def8-44aa-bf99-4825afb8c6bb"
---

Cohesion layout revisions are created at the same time as node revisions, but not always deleted at the same time.

Cohesion Layout revisions are being created and deleted whenever a node revision is created or deleted. This means that for each revision of the node with Layout Canvas there will be a Cohesion Layout Revision entity. This is normal behaviour for revisionable content entities in Drupal, however in specific scenarios it can become problematic if regularly updated nodes have a long lifespan (Homepage Node, for example).

There is an unresolved [issue](https://www.drupal.org/project/drupal/issues/2978521) in Drupal Core about entity reference field items not being removed when the referenced entity is deleted. This applies to Cohesion Layout Revision entities. This means that if a node is deleted, the deletion process removes the node and its revisions, but not composite entities referenced by the node. In the case of Site Studio, this means that Cohesion Layout Revisions for deleted nodes are being left in the database as orphaned entities.  
For more information, see [Managing revisions](/drupal-starter-kits/add-ons/site-studio/managing-revisions "Managing revisions").