big performance problem when using webform with profile fields
espie - October 7, 2009 - 10:08
| Project: | Webform |
| Version: | 6.x-2.7 |
| Component: | Code |
| Category: | bug report |
| Priority: | normal |
| Assigned: | Unassigned |
| Status: | closed |
Description
I have a somewhat big site (1000 users, 6000 profile field values).
I was having problems downloading submissions (csv format) from a large webform: 200 submissions, 80 questions: server timeout after a few minutes.
I tracked it down to profile_load_profile, which takes 20 ms to execute on my db.
when I commented it out, I got it instantly.
I haven't looked too closely at the code, but I think it's invoked repeatedly to load the same profile from global user...
#1
Here's a patch that caches the values...
#2
Ping ? anyone alive ? I know you fixed a security bug, but this is a serious problem. Hampers down my site seriously, and the patch does indeed fix the problem
#3
This problem was actually fixed in the security update in the 2.8 version. Unfortunately that also broke profile values entirely, which was fixed in #604958: %profile default values broken. This patch is no longer necessary.
#4
Automatically closed -- issue fixed for 2 weeks with no activity.