Searchwindow and Template changing slow

[managedata]

Hello,

when I start a search (magnifying glass icon in the dashboard) it takes 46 seconds for the window to open. If I select another template in the open search window, it takes a similar amount of time. The MariaDB database does not show any statements that last more than 10 seconds.

I checked the AgentTicketSearch.pm file and the problem is probably caused by the line 'if (! $ Self -> {Profile} ||! $ Self -> {SaveProfile}) {'.

It looks like there is some problem loading / checking the profiles.

# fill up profile name (e.g. with last-search)
if ( !$Self->{Profile} || !$Self->{SaveProfile} ) {
$Self->{Profile} = Translatable('last-search');
}

I am thankful for any hint.

[managedata]

The problem was the 500.000 SLAs and services in the system. The system can handle such an amount of SLAs but very slowly. We use a database addon from a 3rd party company to store our SLAs/services in a user defined OTRS table. The standard SLA ans services are not used any longer.