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.
Fulltext search too slow (approx. 20 seconds)
Moderator: crythias
Re: Fulltext search too slow (approx. 20 seconds)
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
"Testing": ((OTRS Community Edition)) and git Master
Never change Defaults.pm! :: Blog
Professional Services:: http://www.otrs.com :: enjoy@otrs.com
-
- Znuny newbie
- Posts: 34
- Joined: 03 Jul 2014, 13:48
- Znuny Version: 6.0.18
- Real Name: Jorge Lima
- Location: Braga, Portugal
Re: Fulltext search too slow (approx. 20 seconds)
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
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