[dev] datatree performance (again)

[Didi Rieder]

Quoting Jan Schneider <jan at horde.org>:

> Zitat von Didi Rieder <adrieder at sbox.tugraz.at>:
>
>>> What exactly is the problem with this query? The number of entries in
>>> the datatree tables, or the number of queries per time? What happens
>>> if you run the query on the system while it has no load?
>>
>> I think the number of entries. (But maybe the truth is a mixture of both)
>
> A random guess doesn't help us here. These two potential reasons for
> the perfomance loss require completely different solution strategies.

I told you that I'll keep an eye on it, and so I did:

With less users on the system (night time) the queries take less than  
a second. But with many (> 500) concurrent users they can take 8 sec.  
and more.

Didi

-- 
-------------------------
Didi Rieder
adrieder at sbox.tugraz.at
PGPKey ID: 3431D0B0
-------------------------