[otrs] performances

[BALAN, Daniel]

Hi there,

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?
Thank you for your attention.

Daniel

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.otrs.org/pipermail/otrs/attachments/20070719/8010f78c/attachment.html