Answers.Body: <p>Per Oli, I ran <code>./craft gc</code> for garbage collection. The matrix field went from 70+ (sometimes as much as 130) rows to 8. Still a terribly non-normalized database table, but much better than 70 records for one entry.</p>
  <p>Thanks to Oli!</p>
  
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2021-04-22T14:25:32.517Z
Answers.LastActivityDate: 2021-04-22T14:25:32.517Z
Answers.UserDisplayName: Akuden 
Body: <p><a href="https://i.sstatic.net/EoQb7.png" rel="nofollow noreferrer"><img src="https://i.sstatic.net/EoQb7.png" alt="Large amount of duplication the matrix field is producing" /></a></p>
  <p>The matrix field in Craft CMS is producing massive quantities of duplicate data. About 70 database rows per entry. Is there something I'm doing wrong? I don't think this will be sustainable for my database. The image embedded displays a fraction of the entries into the matrix table for a single Craft CMS structure entry.</p>
  <p>Using Craft Pro 3.6.12</p>
  
Comments.ContentLicense: CC BY-SA 4.0
Comments.CreationDate: 2021-04-22T07:57:56.100Z
Comments.Text: Maybe those are just revisions / drafts?
Comments.UserDisplayName: MoritzLost
Comments.ContentLicense: CC BY-SA 4.0
Comments.CreationDate: 2021-04-22T10:17:47.597Z
Comments.Text: Soft deletes too. Running `./craft gc` would probably get rid of some of those.
Comments.UserDisplayName: Oli
Tags: <matrix><database>
Title: Why does the matrix field produce such a massive amount of duplicate information?
ThreadText: # Why does the matrix field produce such a massive amount of duplicate information?
  
  (Asked by: username_0 on 2021-04-21)
  
  [![Large amount of duplication the matrix field is producing](https://i.sstatic.net/EoQb7.png)](https://i.sstatic.net/EoQb7.png)
  
  The matrix field in Craft CMS is producing massive quantities of duplicate data. About 70 database rows per entry. Is there something I'm doing wrong? I don't think this will be sustainable for my database. The image embedded displays a fraction of the entries into the matrix table for a single Craft CMS structure entry.
  
  Using Craft Pro 3.6.12
  
  **Tags:** matrix, database
  
  > **Comments:**
  > **username_1**: Maybe those are just revisions / drafts?  
  > **username_2**: Soft deletes too. Running `./craft gc` would probably get rid of some of those.  
  
  ---
  
  ## 1 answers
  
  ### Answer by username_0 on 2021-04-22. Score: 1 | Accepted answer
  
  Per Oli, I ran `./craft gc` for garbage collection. The matrix field went from 70+ (sometimes as much as 130) rows to 8. Still a terribly non-normalized database table, but much better than 70 records for one entry.
  
  Thanks to Oli!
  
  
  ---
  
  