Dear Listers,
We are on ITSM 7.1.0 and are wondering if any of you have seen performance
issues using the overview console. We have a situation where some of our users
are members of multiple (12 - 20) groups and when they launch the Overview
Console, the table field takes over a minute to load all the tickets for all
the groups that the users belong to. I realize that the table field is pointing
to an OOB plugin and I am not sure the details of the plugin are readily
available.
Does anyone out there know the details of the plugin and related details that
may help answer the following questions:
* The fields used in the plugin to pull the data from mulitple groups -
is that based on Assigned Group Name or Assigned Group ID, so that we can index
the appropriate fields.
* Incident form already has 15 fields indexed. So, the insert/update
performance maybe less than ideal. Any experiences with having more than 15
fields with index on the Incident form?
* Have any of you indexed the Group Name fields on the underlying forms
that provide the data to the Overview Console and the associated performance
impact for seraching/inserting/updating?
* What other considerations would be useful for improving the table
field data load performance?ITSM 7.1 Patch 6 on ARS 7.1.0 Patch 6 on RHEL
Oracle 10gR3 on RHEL
Thanks in advance,
--
Shyam
_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor:[email protected] ARSlist: "Where the Answers Are"