[dev] datatree performance (again)

[Didi Rieder]

Quoting Didi Rieder <adrieder at sbox.tugraz.at>:

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

The "status" command also tells me that there are quite a lot of  
queries per second:

Uptime:                 21 days 20 hours 24 min 42 sec
Questions:              183882653
Queries per second avg: 97.402

so it is about 100 queries / sec. on average in the last 21 days,  
which include nighttime and holidays.

Didi

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