OTRS Suspiciously slow

Howdy All, No matter the platform MySQL or PostgreSQL I am getting painfully slow performance in OTRS with even just a few hundred tickets. We're talking load times of almost 30-40 seconds to get the AgentTicketQueue to come up. I'm not sure what is going on - even the support assessment tool reports absurdly high times. Ranging from 10-20 seconds depending on whether it is a SQL insert/update/create...etc What is going on guys? Where can I start to look at this. It really seems to be the AgentTIcketQueue that causes the most problem (or any view that shows lots of tickets at once). :( :( Best Regards, Mike McMahon

Hi Mike, 08/08/2013 21:38 - McMahon Mike wrote:
What is going on guys? Where can I start to look at this. It really seems to be the AgentTIcketQueue that causes the most problem (or any view that shows lots of tickets at once).
If the queue view is the place where you see most performance problems, I suspect the main problem is actually in the configuration of your customer data source. What data source you use? LDAP? Can you try disabling the customer data source and opening the queue view again? -- Michiel

You are correct, it is LDAP and it has to search against three different trees for our three different domains. Unfortunately the way our team (accounts) setup the AD tree it is very dirty and people can be located in many places so the search has to go through many many branches and thus I have it starting at the top of the tree!! Best Regards, Mike McMahon -----Original Message----- From: dev-bounces@otrs.org [mailto:dev-bounces@otrs.org] On Behalf Of Michiel Beijen Sent: Friday, August 9, 2013 12:03 AM To: dev@otrs.org Subject: Re: [dev] OTRS Suspiciously slow Hi Mike, 08/08/2013 21:38 - McMahon Mike wrote:
What is going on guys? Where can I start to look at this. It really seems to be the AgentTIcketQueue that causes the most problem (or any view that shows lots of tickets at once).
If the queue view is the place where you see most performance problems, I suspect the main problem is actually in the configuration of your customer data source. What data source you use? LDAP? Can you try disabling the customer data source and opening the queue view again? -- Michiel _______________________________________________ OTRS mailing list: dev - Webpage: http://otrs.org/ Archive: http://lists.otrs.org/pipermail/dev To unsubscribe: http://lists.otrs.org/cgi-bin/listinfo/dev
participants (2)
-
McMahon, Mike (HQP)
-
Michiel Beijen