Slow response time accessing item records in GUI

• Article Type: General
• Product: Aleph
• Product Version: 19.01

Description:
We get extraordinarily slow response time when trying to retrieve high-numbered z30 records in the GUI Items client.

Resolution:
The problem was the z50 table in the JTS50 library. (The ./pc_item/pc_item_ calls the ./com_io/set_znn_time_stamp program which reads the xxx50 z50 table.)

util a/17/14 for the z50 showed that the z50_id Oracle index was missing. And this SQL:

SQL-xxx50> select count(*) from z50;

showed that there were 7,128,127 z50 records! The z50 table is supposed to be cleared out nightly by util a/12.