[horde] Performance Issues, Input Requested

[Chuck Hagenbuch]

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.

-chuck

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