OTRS and search

[eda]

Hi

My experience is that OTRS is extremely slow at search. Looking for all emails with a special FROM adr takes more time than it takes for google to look the whole internet for something. Is it problem with our setup or is it general issue?

Also when you have found number tickets and do something to one of tickets i.e. closing then you have repeat the slow search to see the tickets again. Kind annoying but not a big problem if search was fast.

Erling

[Wolfgangf]

"slow on search" is a bit generic

probably you should start by checking performance of otrs by running Sysconfig -> [ Support Assessment ] and follow the instructions from there
also try the SQL on the left top of [ Support Assessment ] and check the values
another point is probably running mysqltuner https://github.com/rackerhacker/MySQLTuner-perl (if you run a MySQL database)
how about your hardware? is your IO throughput OK? Which discs (10K, 15K, ...)
enough memory? swapping

So, a lot you can do for your performance ...
Of course you can also install a 2700 mainboard performance cluster per shelf (how many shelfs would you like )like google and your search will be a bit faster then

P.S: fill your signature please

[eda]

I understand your point about hardware. But my OTRS installation is for a small (<=10) user OTRS installation. So if you compare the size of the hardware for us and Google and the size of databases, then my dedicated server is most likely bigger than all Googles data centers in a relative sense.

I would think that find find all tickets from certain email should be instantaneous. It is not. I can

[Wolfgangf]

eda - did you check the sysconfig -> Support assassement already?
what did mysqltuner say?

[eda]

Hi

sqltuner said we run optimize on our table. We did not quite understand what you meant by

did you check the sysconfig -> Support assassement already?

what is the exact step to do it. Sorry about our ignorance.

[Wolfgangf]

if mysqltuner tells you: run optimize, please refer to the mysql admin docu
anyway, you can run

Code: Select all

mysqlcheck -o otrs 

from the commandline

For Support Assesement: go to [Admin] and you'll find it in the menu then

[dschulz]

Search in OTRS is implemented in a very poor way. Don't expect it to get much faster than it is ... unless you touch the source code of course.