Maximo List Archive - CLASSIFICATION SEARCH window takes 45 sec to render

This is an archive of the Maximo Yahoo Community. The content of this pages may be a sometimes obsolete so please check post dates.
Thanks to the community owner Christopher Wanko for providing the content.

CLASSIFICATION SEARCH window takes 45 sec to render

From: eric.klemenok (2014-12-03 06:35)

Basis:
You have implemented a complete CLASSIFICATION system for use on ITEM MASTERS which involves all the underlying tables which are sizeable. SQL is the backend db.

Issue:
When you click the chevron (>>) next to Item field and select CLASSIFICATION, it takes 30-45 sec for the pop-up window to appear. This is the window that has the CLASSES on the left and the ATTRIBUTES to the right. The CLASSES are shown in a hierarchial drill-style view.

Details:
Table indexing is enabled on the SQL db.

Question:
Are there other settings, possibly within Maximo, that impact the time it takes to display the search box ?

From: maximo list owner (2014-12-03 11:13)

Maximo version?
On Wed, Dec 3, 2014 at 9:35 AM, eric.klemenok@mallinckrodt.com [MAXIMO] <
MAXIMO@yahoogroups.com> wrote:
>
>
>
> Basis:
> You have implemented a complete CLASSIFICATION system for use on ITEM
> MASTERS which involves all the underlying tables which are sizeable. SQL is
> the backend db.
>
> Issue:
> When you click the chevron (>>) next to Item field and select
> CLASSIFICATION, it takes 30-45 sec for the pop-up window to appear. This is
> the window that has the CLASSES on the left and the ATTRIBUTES to the
> right. The CLASSES are shown in a hierarchial drill-style view.
>
> Details:
> Table indexing is enabled on the SQL db.
>
> Question:
> Are there other settings, possibly within Maximo, that impact the time it
> takes to display the search box ?
>
>
>
>
>
>