Fulltext search too slow (approx. 20 seconds)

Moderator: crythias

Post Reply
OTRS newbie
Posts: 1
Joined: 07 Nov 2019, 10:59
Znuny / OTRS Version: 6.0
Real Name: David Szoboszlay
Company: Opale Solutions SA

Fulltext search too slow (approx. 20 seconds)

Post by DavidS »


I have a problem with OTRS fulltext research. When I search a ticket number, that's quick (~2 seconds) but with text, I have more than 20 seconds to wait. I already set the research on staticDB and we've done the tasks

bin/otrs.Console.pl Maint::Ticket::FulltextIndex --rebuild
bin/otrs.Console.pl Maint::Ticket::QueueIndexRebuild

When I do a SQL request with text on Mime_data, it take 4 seconds but when I do the same with fulltext fields it's more than 20 seconds.

Could you help me what I have to check in my OTRS configuration ?

OTRS Employee
Posts: 14921
Joined: 26 Jan 2007, 14:50
Znuny / OTRS Version: Git Master

Re: Fulltext search too slow (approx. 20 seconds)

Post by jojo »

you need to tune your database and invest in faster disk I/O, Memory etc on your database server
"Production": OTRS™ 8, OTRS™ 7, STORM powered by OTRS
"Testing": ((OTRS Community Edition)) and git Master

Never change Defaults.pm! :: Blog
Professional Services:: http://www.otrs.com :: enjoy@otrs.com
OTRS newbie
Posts: 34
Joined: 03 Jul 2014, 13:48
Znuny / OTRS Version: 6.0.18
Real Name: Jorge Lima
Location: Braga, Portugal

Re: Fulltext search too slow (approx. 20 seconds)

Post by jlima »

are you using ticket archive?
If not, you should consider that. I got considerable improvements in search times although some searches (full text with several words) still take their time.
best regards
OTRS 6.0.18 (public/testing) on CentOS with Postgres database
Post Reply