Answers.Body: <p>I have never tried but I think you are correct.</p>
  
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2024-06-24T06:48:12.893Z
Answers.LastActivityDate: 2024-06-24T06:48:12.893Z
Answers.UserDisplayName: ErikH - CiviCooP
Body: <p>I just would like to make sure I have the correct understanding of what happens when adding an image or an attachment to a Civimail / mass mailing, let's say sent to 500 contacts.
  I have CKEditor5 installed and configured with &quot;uploaded images&quot; (instead of embedded images)
  Until now, I have asked our users to avoid attaching files and images in civimail, because I was worried about the impact on the database size.</p>
  <p>Are the following statements correct ?</p>
  <ol>
  <li><p>when adding an image inline in the email body, by using the toolbar icon &quot;add an image or file&quot; : there is no impact on the database size. The file is stored once in the file system, and NOT 500 times in the database
  <a href="https://i.sstatic.net/E4vyE9nZ.png" rel="nofollow noreferrer"><img src="https://i.sstatic.net/E4vyE9nZ.png" alt="enter image description here" /></a></p>
  </li>
  <li><p>Embedding the image in the email body by a &quot;copy paste&quot; operation has a severe impact on the database : the image is stored 500 times</p>
  </li>
  <li><p>using the &quot;attachments&quot; button in civimail has the same impact as in option 1) above
  : the file is stored only once
  <a href="https://i.sstatic.net/Wi2HsaWw.png" rel="nofollow noreferrer"><img src="https://i.sstatic.net/Wi2HsaWw.png" alt="enter image description here" /></a></p>
  </li>
  </ol>
  <p>Is all of the above correct ?</p>
  
Tags: <civimail>
Title: Database size when attaching image in civimail
ThreadText: # Database size when attaching image in civimail
  
  (Asked by: username_0 on 2024-06-16)
  
  I just would like to make sure I have the correct understanding of what happens when adding an image or an attachment to a Civimail / mass mailing, let's say sent to 500 contacts.
  I have CKEditor5 installed and configured with "uploaded images" (instead of embedded images)
  Until now, I have asked our users to avoid attaching files and images in civimail, because I was worried about the impact on the database size.
  
  Are the following statements correct ?
  
  1. when adding an image inline in the email body, by using the toolbar icon "add an image or file" : there is no impact on the database size. The file is stored once in the file system, and NOT 500 times in the database
     [![enter image description here](https://i.sstatic.net/E4vyE9nZ.png)](https://i.sstatic.net/E4vyE9nZ.png)
  2. Embedding the image in the email body by a "copy paste" operation has a severe impact on the database : the image is stored 500 times
  3. using the "attachments" button in civimail has the same impact as in option 1) above
     : the file is stored only once
     [![enter image description here](https://i.sstatic.net/Wi2HsaWw.png)](https://i.sstatic.net/Wi2HsaWw.png)
  
  Is all of the above correct ?
  
  **Tags:** civimail
  
  
  ---
  
  ## 1 answers
  
  ### Answer by username_1 on 2024-06-24. Score: 0
  
  I have never tried but I think you are correct.
  
  
  ---
  
  