Body: <p>After a recent update (Craft 3.4.x to 3.5.x) I'm seeing some suspiciously slow response times in relation to <code>INSERT</code> actions on the <code>resourcepaths</code> table. Some in the upwards of a half second for a single transaction.</p>
  <p>Has anyone ever encountered this before? One note, this is hosted on a load-balanced environment so I'm not sure if this plays into this (if at all).</p>
  <p><a href="https://i.sstatic.net/fHAcI.png" rel="nofollow noreferrer"><img src="https://i.sstatic.net/fHAcI.png" alt="Yii debug toolbar showing slow durations for the INSERT transactions in the craft_resourcepaths table" /></a></p>
  
Comments.ContentLicense: CC BY-SA 4.0
Comments.CreationDate: 2021-03-17T16:27:51.497Z
Comments.Text: This issue is happening to me as well but using a PostgreSQL, did you find any solutions @Aaron Bushnell?
Comments.UserDisplayName: José Veríssimo
Comments.ContentLicense: CC BY-SA 4.0
Comments.CreationDate: 2021-12-08T21:40:17.037Z
Comments.Text: I'm on Craft 3.7.21 and just experienced something similar. Except the UPSERT queries were taking up to a minute or more, and taking down my site. Did you ever find a reason or solution to this one
Comments.UserDisplayName: Gary Reckard
Tags: <database><performance><mysql><yii><load-balancer>
Title: Very slow `INSERT` transactions on the resourcepaths table
ThreadText: # Very slow `INSERT` transactions on the resourcepaths table
  
  (Asked by: username_0 on 2021-02-14)
  
  After a recent update (Craft 3.4.x to 3.5.x) I'm seeing some suspiciously slow response times in relation to `INSERT` actions on the `resourcepaths` table. Some in the upwards of a half second for a single transaction.
  
  Has anyone ever encountered this before? One note, this is hosted on a load-balanced environment so I'm not sure if this plays into this (if at all).
  
  [![Yii debug toolbar showing slow durations for the INSERT transactions in the craft_resourcepaths table](https://i.sstatic.net/fHAcI.png)](https://i.sstatic.net/fHAcI.png)
  
  **Tags:** database, performance, mysql, yii, load-balancer
  
  > **Comments:**
  > **username_1**: This issue is happening to me as well but using a PostgreSQL, did you find any solutions @username_0?  
  > **username_2**: I'm on Craft 3.7.21 and just experienced something similar. Except the UPSERT queries were taking up to a minute or more, and taking down my site. Did you ever find a reason or solution to this one  
  
  ---
  
  ## 0 answers
  
  