Answers.Body: <blockquote>
  <p>Can someone explain what’s happening?</p>
  </blockquote>
  <p>Let's assume we're talking about Craft 4 and not Craft 3.</p>
  <p>Native Craft elements include:</p>
  <ul>
  <li>Entries</li>
  <li>Categories</li>
  <li>Tags</li>
  <li>Assets</li>
  <li>Globals</li>
  <li>Matrix Blocks (one element per block)</li>
  <li>Users</li>
  <li>Addresses</li>
  </ul>
  <p>Plugins can also add their own elements. Super Table and Neo are similar to Matrix in that it’s one element per block.</p>
  <p>It's pretty easy for a single entry to create 200 elements depending on the information architecture and plugins installed.</p>
  <p>If it’s a multi-site installation, then you have X elements per entry times Y number of sites the entry has to be propagated to.</p>
  <p>Craft’s revisions and drafts are also elements (like entries), so when Craft creates a revision when you’re editing an entry, that’s another element multiplier.</p>
  <blockquote>
  <p>And do I need to do something about it?</p>
  </blockquote>
  <p>Nah. :)</p>
  
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2023-05-11T18:02:39.593Z
Answers.LastActivityDate: 2023-05-11T18:02:39.593Z
Answers.UserDisplayName: Brad Bell
Body: <p>I noticed that the ID number of my entries has increased to almost 50.000, but I have around 1.000 entries and 2.000 files. I understand that other things like categories also affect that number, but it still seems high.</p>
  <p>I looked at the database and found that whenever I add an entry, around 200 additional lines are created in craft_elements_sites. All have slug and uri set to NULL, except between maybe one and five that have the entry’s uri and slug. From what I can see, I think it has something to do with matrix fields, but it also looks like temp or drafts since the same uri is repeated and the timestamps are identical.</p>
  <p>Can someone explain what’s happening? And do I need to do something about it?</p>
  
Tags: <database><craft4>
Title: 200 new lines in elements_sites per entry
ThreadText: # 200 new lines in elements_sites per entry
  
  (Asked by: username_0 on 2023-05-11)
  
  I noticed that the ID number of my entries has increased to almost 50.000, but I have around 1.000 entries and 2.000 files. I understand that other things like categories also affect that number, but it still seems high.
  
  I looked at the database and found that whenever I add an entry, around 200 additional lines are created in craft\_elements\_sites. All have slug and uri set to NULL, except between maybe one and five that have the entry’s uri and slug. From what I can see, I think it has something to do with matrix fields, but it also looks like temp or drafts since the same uri is repeated and the timestamps are identical.
  
  Can someone explain what’s happening? And do I need to do something about it?
  
  **Tags:** database, craft4
  
  
  ---
  
  ## 1 answers
  
  ### Answer by username_1 on 2023-05-11. Score: 2 | Accepted answer
  
  > Can someone explain what’s happening?
  
  Let's assume we're talking about Craft 4 and not Craft 3.
  
  Native Craft elements include:
  
  * Entries
  * Categories
  * Tags
  * Assets
  * Globals
  * Matrix Blocks (one element per block)
  * Users
  * Addresses
  
  Plugins can also add their own elements. Super Table and Neo are similar to Matrix in that it’s one element per block.
  
  It's pretty easy for a single entry to create 200 elements depending on the information architecture and plugins installed.
  
  If it’s a multi-site installation, then you have X elements per entry times Y number of sites the entry has to be propagated to.
  
  Craft’s revisions and drafts are also elements (like entries), so when Craft creates a revision when you’re editing an entry, that’s another element multiplier.
  
  > And do I need to do something about it?
  
  Nah. :)
  
  
  ---
  
  