Skip to main content
ExLibris

Knowledge Assistant

BETA
 
  • Subscribe by RSS
  • Back
    Aleph

     

    Ex Libris Knowledge Center
    1. Search site
      Go back to previous article
      1. Sign in
        • Sign in
        • Forgot password
    1. Home
    2. Aleph
    3. Knowledge Articles
    4. Slow response time accessing item records in GUI

    Slow response time accessing item records in GUI

    1. Last updated
    2. Save as PDF
    3. Share
      1. Share
      2. Tweet
      3. Share
    1. Additional Information
    • 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.

    Additional Information

    response time, item records, GUI,


    • Article last edited: 10/8/2013
    View article in the Exlibris Knowledge Center
    1. Back to top
      • Slow response in TWO_TASK caused by distance between App server <-> Firewall <-> DB server
      • Slow sql processing in Oracle Prod (vs Test)
    • Was this article helpful?

    Recommended articles

    1. Article type
      Topic
      Language
      English
      Product
      Aleph
    2. Tags
      1. 19.01
      2. contype:kba
      3. Prod:Aleph
      4. Type:General
    1. © Copyright 2025 Ex Libris Knowledge Center
    2. Powered by CXone Expert ®
    • Term of Use
    • Privacy Policy
    • Contact Us
    2025 Ex Libris. All rights reserved