Display of HOL record extremely slow.

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

Description:
After upgrading to version 18, the display of HOL records is extremely slow.

The display of expanded fields (852, 866) from HOL records in the Web Full display is OK, but the display of the OPAC Holdings is extremely slow; as is:
the display of the HOL record in GUI Cataloging when you click on Edit [HOL] in the Bib record display,
the display of the HOL record when you connect to the xxx60 library, and
the display of the tree in the left-hand pane when you display an HOL record. [ <Jerry Specht > ]

Resolution:
If all access of the HOL record were slow, that would point to a problem with the xxx60 z00_id Oracle index, but this case where display of the records via expand is OK, while direct access is extremely slow, points to a problem with the xxx60 z103 table. (This is because the bar at the top of the GUI HOL display includes the title, which comes from the bib z13 table.)

util a/17/14 showed that the xxx60 z103_id and z103_id1 Oracle indexes were OK. Rebuilding these indexes via util a/17/3 did not help.

Exporting the xxx60 z103 table (using p_file_03) and importing it (using p_file_04) corrected the problem.