Edwind Richzendy Contreras Soto schreef op 2012-05-14 07:15:
1) It is appropriate to have so many services? (I did
not do the
configuration of OTRS)
Most organizations use less services, typically between 50 and 100, but
sometimes also more.
2) why are so many queries to the database?
3) that information is not stored in cache to make selection faster
OTRS 3.1.3 and up (tomorrow we'll release 3.1.5) will use much less
queries to the database; it will use much more caching.
What also might help is if you do not store sessions in the database,
but on the file system (see Core::Session under Admin > SysConfig >
4) If I type ACL Queue-> Services , the charging
time will be
faster service? and related services only appear to the queue defined
in the ACL?
5) as I can make the load time of service is much faster?
The strange thing is that the queries in your database do not take the
most time, right? They all execute in the same second, apparently. It
might be interesting, using a profiler, to learn where your system is
spending this much time: in the database, or maybe in the application
If you want, you can install 'Fred' - a helper tool for OTRS
development - from here:
it features Devel::NYTProf integration, so you can analyze exactly what
is happening. Of course you should only want to install Fred on a dev
machine, NOT on production!