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 display of GUI Items List when there are many items with many loans

    Slow display of GUI Items List when there are many items with many loans

    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: 20, 21, 22, 23

    Description:
    Aleph is very slow in displaying the GUI Items List when there are many items with many loans (e.g. laptops, e-readers, DVDs, CD's, etc.).

    This is happening in both Cataloging and Circulation.

    In Cataloging, it happens if I simply select one of the items : Aleph freezes ("blue circle") for too long.
    With Circulation, just scanning the item's barcode makes Aleph freeze.

    The "blue circle" lasts for a minute or more, and sometimes Aleph cannot go through, so the client needs to be stopped.

    Resolution:
    The Items List function reads all the z36h records for this ADM's item records (in order to get the count of "Loans" for each item) and all of the z30h records (in order to get the "Last updated" date in "History" in the tree on the left). And, in Cataloging, the "Items List -- All Items History" display.

    See Slow check-out of items which have been loaned many times  (KB 16384-18930)  -- because check_circ_7_c checks all of the z36h records to find the most recent return.

    To deal with the current situation, you may want to delete older z30h records. With version 22.1, rep_change 2020, this can be done with util x/13. Otherwise, SQL would need to be used.  (Note:  with util x/13 doesn't distinguish "All fields" history records from others.  The article " Unnecessary z30h history records " has SQL for deleting old "All fields" records.) 

    To prevent the problem's reoccurrence in the future, you should change the last line in the distributed tab_item_history.eng from:

    ALL-FIELDS L All fields

    to:

    ALL-NON-CIRC L Other non-circ updates

    Additional Information

    This would be done once all the statistics for a particular time-period have been gathered. Prior to version 22, it would need to be done via SQL, but, with 22.01 rep_change 2020, util x/13 has been added do this.


    • Article last edited: 3/19/2014
    View article in the Exlibris Knowledge Center
    1. Back to top
      • Slow check-out of items which have been loaned many times
      • Slow display of Netlibrary and Electronic Book titles in GUI Full Link
    • Was this article helpful?

    Recommended articles

    1. Article type
      Topic
      Language
      English
      Product
      Aleph
    2. Tags
      1. 20
      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