mod_perl for sure. There are queries running for hundreds and hundreds seconds. Daniel
-----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] 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. _______________________________________________ OTRS mailing list: otrs - Webpage: http://otrs.org/ Archive: http://lists.otrs.org/pipermail/otrs To unsubscribe: http://lists.otrs.org/cgi-bin/listinfo/otrs Support or consulting for your OTRS system? => http://www.otrs.com/
