<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>

CC BY-SA 4.0
2021-04-22T14:25:32.517Z
2021-04-22T14:25:32.517Z
Akuden 
<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>

CC BY-SA 4.0
2021-04-22T07:57:56.100Z
Maybe those are just revisions / drafts?
MoritzLost
CC BY-SA 4.0
2021-04-22T10:17:47.597Z
Soft deletes too. Running `./craft gc` would probably get rid of some of those.
Oli
<matrix><database>
Why does the matrix field produce such a massive amount of duplicate information?
# 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 username_2, 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 username_2!


---

