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

CommentFileSizeAuthor
#1 w.patch772 bytesespie

Comments

espie’s picture

espie commented
Status: Active » Needs review
StatusFileSize
new w.patch772 bytes

Here's a patch that caches the values...

espie’s picture

espie commented

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

quicksketch’s picture

quicksketch
he/him
commented
Priority: Critical » Normal
Status: Needs review » Fixed

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 and %server default values broken. This patch is no longer necessary.

Status: Fixed » Closed (fixed)

Automatically closed -- issue fixed for 2 weeks with no activity.