mod_perl for sure. There are queries running for hundreds and hundreds seconds. Daniel -----Original Message----- From: otrs-bounces@otrs.org [mailto:otrs-bounces@otrs.org] On Behalf Of Nils Breunese (Lemonbit) Sent: Thursday, July 19, 2007 8:09 PM To: User questions and discussions about OTRS.org Subject: Re: [otrs] performances Daniel Balan wrote:
I am using OTRS since v0.8 ( more than 3 years history) and it gets bigger and bigger:
- Database = 5.9 Gb;
- More than 1.4 ml records in article table and 0.4 ml records in the ticket table;
- The attachments are stored in FS mode and those are exceeding 250 Gb.
- About 25 operators with concurrent access
I am using v2.0.2 on a Linux + MySql installation.
The problem is that OTRS is moving slowly and slowly, for example changing the owner of the ticket might take 20-25 seconds. Setting a free field the same.
I had to disable search option in body and subject as those will take forever.
Does anyone encountered similar issues or has any suggestions what other DB (oracle) will perform better?
Have you checked it's de database queries that take a long time? I do hope you're using mod_perl and don't run OTRS in CGI mode? Nils Breunese.