[horde] Performance Issues, Input Requested

[Jan Schneider]

Zitat von Chuck Hagenbuch <chuck at horde.org>:

> Quoting Brandon Knitter <knitterb at blandsite.org>:
>
>> I've noticed recently that clicking simple things like messages, or  
>> "Inbox", are taking excessive server load.  The server load appears  
>> to be in the httpd process.  I found this recently when I was using  
>> SyncML, and now it's apparently timing out.  I don't see the MySQL  
>> process taking up much CPU, nor much IO Wait on the system.
>>
>> I turned on DEBUG logging for a few clicks  (I'm really the only  
>> one using this system at nite) and I find a TON of queries being  
>> performed, many of them on the DataTree objects/table.  A lot of  
>> queries are also run when I do the same debug logging of a SyncML  
>> request.
>>
>> How can I start gathering the appropriate information on the  
>> performance issues with my installation?  Again, I've not changed  
>> anything recently, so it must simply be data growth of my calendar  
>> and other items.  Would be great if I could get SyncML (which I  
>> love) to only sync new calendar items! ;-)
>
> Well, History stuff was moved out of the datatree in 3.1, which  
> should help you a lot. The rest is probably Shares and permissions  
> checks. You can look at the query logs to see whether the queries  
> can be made more efficient, or you can help us rewrite things to not  
> use DataTree anymore.

Or you could upgrade to Horde CVS which has support for caching Shares  
and Groups.

Jan.

-- 
Do you need professional PHP or Horde consulting?
http://horde.org/consulting/