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

CC BY-SA 4.0
2021-03-17T16:27:51.497Z
This issue is happening to me as well but using a PostgreSQL, did you find any solutions @Aaron Bushnell?
José Veríssimo
CC BY-SA 4.0
2021-12-08T21:40:17.037Z
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
Gary Reckard
<database><performance><mysql><yii><load-balancer>
Very slow `INSERT` transactions on the resourcepaths table
# 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 @Aaron Bushnell?  
> **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

