[imp] Performance after upgrade

[Stephen A. Cochran Lists]

I just upgraded from Horde 3.0.x/IMP 4.0.3 to Horde 3.1.1/IMP 4.1.1.

Before the upgrade, the CPU was mostly idle. After the upgrade I've  
noticed fairly poor performance. I just logged on and apache was  
using 100% of the CPU:

PID USER      PR  NI  VIRT  RES  SHR S %CPU %MEM    TIME+  COMMAND
9655 apache    25   0 41144  21m  16m R 13.3  2.1 148:33.29 httpd
10389 apache    25   0 42948  22m  16m R 13.3  2.2  75:13.65 httpd
9648 apache    25   0 43004  18m  14m R 12.3  1.8 510:46.03 httpd
9642 apache    25   0 43048  24m  16m R 11.0  2.4 128:10.01 httpd
9641 apache    25   0 43228  24m  16m R 10.3  2.4 181:06.34 httpd
9643 apache    25   0 44648  21m  16m R 10.0  2.1  85:47.41 httpd
9645 apache    25   0 41036  20m  15m R 10.0  2.1 179:49.97 httpd
9646 apache    25   0 44128  22m  16m R 10.0  2.2 120:10.17 httpd
9647 apache    25   0 42152  18m  15m R 10.0  1.9 160:27.47 httpd
9657 apache    25   0 41004  20m  15m R 10.0  2.0 183:30.14 httpd
9687 apache    25   0 44712  23m  16m R 10.0  2.3  74:18.54 httpd
9690 apache    25   0 44236  24m  16m R 10.0  2.4 101:57.41 httpd
10317 apache    25   0 44184  24m  16m R 10.0  2.4  74:20.90 httpd
10388 apache    25   0 42928  19m  16m R 10.0  1.9  72:14.31 httpd
10484 apache    25   0 42384  19m  15m R 10.0  1.9  74:01.57 httpd
10485 apache    25   0 42628  22m  14m R 10.0  2.3  70:57.77 httpd
10536 apache    25   0 40016  17m  14m R 10.0  1.7  72:42.74 httpd
10555 apache    25   0 39704  17m  12m R 10.0  1.7  71:49.96 httpd
10586 apache    25   0 39800  19m  14m R 10.0  2.0  63:12.42 httpd


 From the horde log, the only notable thing is lots of the following  
lines, sometimes several a second, sometimes one every 1-5 seconds.  
Hard to tell how high the load is on this server, but it's not very  
high. Are the preferences called on login or constantly during a  
session?

Apr 19 02:11:17 HORDE [debug] [] SQL Query by Prefs_sql::retrieve():  
SELECT pref_scope, pref_name, pref_value FROM horde_prefs WHERE  
pref_uid = ? AND (pref_scope = ? OR pref_scope = 'horde') ORDER BY  
pref_scope [on line 132 of "/var/www/html/mail/horde/lib/Horde/Prefs/ 
sql.php"]

Restarting apache seems to have cleared the CPU log for now, but any  
idea what could cause the httpd processes to all suck so much CPU time?

Steve Cochran