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