We have been suffering, maybe forever, with painfully slow Magento admin performance. It could take 30 seconds just to login for an admin user (users with less privledges did not have issues). The issue seems to be related to a module called VladamirPopv and webforms.
The strace revealed many queries like the following repeating over and over:
SELECT `webforms_results_values`.* FROM `webforms_results_values` WHERE (webforms_results_values.result_id = 22381)"
There were 34127 queries referencing "SELECT `webforms_results_values`."
[2020][root@ZZZ nexrarthur]$ grep -F 'SELECT `webforms_results_values`' php.strace.6415.1463444269 -c
34127
This appears related to the extension VladimirPopov_WebForms. Below shows the 'stat' command ran on the xml file showing this extension has been installed since at least 2015:
[2019][root@ZZZ html]$ stat app/etc/modules/VladimirPopov_WebForms.xml
File: `app/etc/modules/VladimirPopov_WebForms.xml'
Size: 185 Blocks: 8 IO Block: 4096 regular file
Device: 807h/2055d Inode: 4330875 Links: 1
Access: (0664/-rw-rw-r--) Uid: ( 1001/shambhal) Gid: ( 1005/shambhal)
Access: 2015-04-29 09:03:40.000000000 -0400
Modify: 2014-11-20 08:12:48.000000000 -0500
Change: 2015-04-30 16:06:35.693217297 -0400
We disabled this extension by changing true to false in the app/etc/modules/VladimirPopov_WebForms.xml file and flushing the cache. This a resolved the slowness we were seeing.
However, now none of the webforms we use for email signups, etc. work. Can anyone tell me what might be happening here?
