After upgrade to latest OTRS 5 from OTRS 4.07, Agent Ticket Status View running slow..its take almost a few minute to load it.
we dont have this issue when on 4.0.7. It has almost 2000 open ticket (as admin).
OS : Centos 7
DB: Postgresql (remote)
Both server on 8gb ram each
As per here https://bugs.otrs.org/show_bug.cgi?id=13940, this query may be the solution, but its for otrs 6.
Code: Select all
create index concurrently idx_article_data_mime_article_id on
article_data_mime(article_id);
UPDATE:
So, im tested these and the screen view go fast again..at least for now.
1. rebuild index
Code: Select all
su -m otrs -c "/opt/otrs/bin/otrs.Console.pl Maint::Ticket::FulltextIndex --rebuild"
su -m otrs -c "/opt/otrs/bin/otrs.Console.pl Maint::Ticket::FulltextIndexRebuildWorker"
su -m otrs -c "/opt/otrs/bin/otrs.Console.pl Maint::Ticket::QueueIndexRebuild"