[Tickets #5869] Very high load when 100+ concurrent users

[bugs at bugs.horde.org]

DO NOT REPLY TO THIS MESSAGE. THIS EMAIL ADDRESS IS NOT MONITORED.

Ticket URL: http://bugs.horde.org/ticket/?id=5869
-----------------------------------------------------------------------
 Ticket             | 5869
 Created By         | lumir.jasiok at vsb.cz
 Summary            | Very high load when 100+ concurrent users
 Queue              | Horde Groupware Webmail Edition
 Version            | 1.0.3
 Type               | Enhancement
 State              | New
 Priority           | 3. High
 Owners             | 
+New Attachment     | leftjoin_to_innerselect-hwe-1.0.3.patch
-----------------------------------------------------------------------


lumir.jasiok at vsb.cz (2007-11-07 00:13) wrote:

After I migrated from Horde2 to HWE1.0.3, the webmail became deadly slow -
even on better HW and OS! That's why I did a research of the code and
optimized one of key SQL queris so that it now works ~40 times faster with
PostgreSQL. It's been tested by thousands of our users in production
environment of my University for two weeks without negative feedback.

The point of the enclosed patch is to replace a LEFT JOIN with inner
SELECT. I was wondering if you made it that way because of some
compatibility issues?

I am aware that the patch may not be considered up to your coding
standards, but for me it works. If possible, please merge the code as soon
as possible so that next security patches won't break the hack for me :-)

Sincerely,

Lumir Jasiok, Ivan Dolezal