There's a package named Support that you should install from Package Manager. After it's installed you'll have a new link in the ADMIN page, named Support Assessment. Follow the link to a page presenting a report about the environment OTRS is running on. The report may load VERY slowly and return timeouts. Keep retrying. When it finally succeeds, go through it and beware of any anomalies as they may clue you into why you're having problems.

Additionally, notice that on the Support Assessment page you have a link in the upper left named SQL benchmark. Follow the link to a page from which you can run a benchmark on the database. This will help evidencing if there are issues for OTRS with the connection between the web server and the db server.

If I understood things correctly, you have the db server on a dedicated machine (call it dbsrv-machine) but you run the VoIP server on the same machine as OTRS (call it websrv-machine). In this case, an additional thing to check would be if the Apache instance running OTRS is starved for resources (memory, etc.).

On Tue, May 13, 2014 at 4:35 PM, Mimiko <vbvbrj@gmail.com> wrote:
On 13.05.2014 16:05, Bogdan Iosif wrote:
I also noticed on my systems that opening SysConfig, and especially
opening Package Manager, is an operation that is much slower than most
others.

Especially when submitting changes.



The Support Package has a builtin benchmarking tool for the database.
Did you run that benchmark? Are the results ok?

I did run Performance Log, from where I've found those seconds. Where is the tool for database?


If everything checks out then the only possible cause that is left
standing is the performance of mod_perl + Apache on your Linux distro.
It would be worth to try a different, more common distro (such us CentOS
or Ubuntu) and trying to run mod_perl and Apache in 32-bit vs 64-bit
modes to see if there are any differences.

Trying other distro is not an option. I don't have physical resources for this. Same Debian handles a VoIP server with database and apache together on other server without a problem.



I'm also tackling some performance issue with my OTRS system as I'm
trying to upgrade from 3.2 to 3.3 on Windows and during my
investigations I've noticed mod_perl has somewhat fallen out of grace,
not just on Windows where it became borderline unusable. You may want to
try mod_fastcgi instead.

I've read in manual that fastcgi is slower than modperl that's why I didn't try it. May be I will try fastcgi.


--
Mimiko desu.
---------------------------------------------------------------------
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