[horde] Simple Solution to 'Database performance problem with Horde3/IMP4 with a large user base'

Chuck Hagenbuch chuck at horde.org
Wed Aug 16 09:59:18 PDT 2006


Quoting Akritidis Xristoforos <Xristoforos.Akritidis at hol.net>:

> The DB performance problem with the datatree permission query reported
> last year has a very simple solution. All you need to do is send many
> different queries instead of a single one with a bunch of OR statements
> in it. mysql will not use an index if your statement has OR clauses with
> the fields comprising the index.
[snip]
> So all one has to do is split the SELECT into 4 queries and join the
> results. I don't know much about PHP or how Horde works, so it will be a
> pain for me to provide the fix. But if someone can point me to the part
> of the code that does it, I will have one of my people do it.

Okay, great. The code is in framework/DataTree/DataTree/sql.php. Also  
see http://bugs.horde.org/ticket/?id=3126 for other potential  
implementations.

-chuck

-- 
"we are plastered to the windshield of the bus that is time." - Chris


More information about the horde mailing list