Fulltext search too slow (approx. 20 seconds)

Moderator: crythias

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

Fulltext search too slow (approx. 20 seconds)

Post by DavidS » 07 Nov 2019, 12:15

Hi,

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 ?

Thank's.

jojo
Moderator
Posts: 14613
Joined: 26 Jan 2007, 14:50
OTRS Version?: Git Master
Contact:

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

Post by jojo » 07 Nov 2019, 12:50

you need to tune your database and invest in faster disk I/O, Memory etc on your database server
"Production": 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 :: Share your ideas

jlima
OTRS newbie
Posts: 34
Joined: 03 Jul 2014, 13:48
OTRS Version?: 6.0.18
Real Name: Jorge Lima
Location: Braga, Portugal

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

Post by jlima » 07 Nov 2019, 19:16

hi
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
jorge
OTRS 6.0.18 (public/testing) on CentOS with Postgres database

Post Reply