Description
Saving an entry takes about 30 to 60 seconds with a lot of duplicated queries (262 duplicated queries found out of 545). Most SELECT id, parentId, volumeId, name, path, uid FROM craft_volumefolders .....
Most duplicated queries come from craft_volumnfolders table.
in the queue.log we found the following lines, which gets repeated for the next ~30sec.
Updating the search index and stoping it right away (time.: 0.081s) 5:34 2021-09-02 17:25:54 [-][101][-][info][craft\queue\QueueLogBehavior::afterExec] [915959] Aktualisiere Suchindexe (attempt: 1, pid: 26012) - Done (time: 0.044s)
2021-09-02 17:25:54 [-][101][-][info][craft\queue\QueueLogBehavior::beforeExec] [915961] Aktualisiere Suchindexe (attempt: 1, pid: 26012) - Started
...
Steps to reproduce
- Save an entry in the control panel
Additional info
- Craft version: 3.7.10
- PHP version: 7.4.23
- Database driver & version: MySQL 5.5.5
- Plugins & versions: Expanded Singles 1.1.4, Neo 2.11.9, Freeform 3.11.10, Redactor 2.8.8, Redirect Manager 1.1.1, SEOmatic 3.4.5, Sprig 1.8.1,
Description
Saving an entry takes about 30 to 60 seconds with a lot of duplicated queries (262 duplicated queries found out of 545). Most SELECT
id,parentId,volumeId,name,path,uidFROMcraft_volumefolders.....Most duplicated queries come from craft_volumnfolders table.
in the queue.log we found the following lines, which gets repeated for the next ~30sec.
Updating the search index and stoping it right away (time.: 0.081s) 5:34 2021-09-02 17:25:54 [-][101][-][info][craft\queue\QueueLogBehavior::afterExec] [915959] Aktualisiere Suchindexe (attempt: 1, pid: 26012) - Done (time: 0.044s)
2021-09-02 17:25:54 [-][101][-][info][craft\queue\QueueLogBehavior::beforeExec] [915961] Aktualisiere Suchindexe (attempt: 1, pid: 26012) - Started
...
Steps to reproduce
Additional info