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. Retrieval of records with many items is very slow

    Retrieval of records with many items is very slow

    1. Last updated
    2. Save as PDF
    3. Share
      1. Share
      2. Tweet
      3. Share
    No headers
    • Article Type: General
    • Product: Aleph
    • Product Version: 20

    Description:
    Many of our law records have many items linked to them. For example. record #885289 has 1895 items. When trying to view the items in the GUI it takes a very long time and in the OPAC you can't view them - it just hangs there and spins. According to a staff member in law, it's a lot slower than it was in v19. I'm not sure if that's the case since we got rid of our v19 so I can't check.

    A few questions:

    * Would the two-task setup we have in v20 (that we didn't in v19) affect the response time for these types of records?
    * Is there any recommendation for maximum number of items per record?
    * Any recommendation for how to handle these types of records in v20?

    Resolution:
    [KB's 16384-29362 and 16384-29378 describe some TWO-TASK issues; the change to TWO-TASK was not relevant in this case....]

    On 9/23 there had been a network problem and our database failed over to another instance. Ever since then we've been having slowness issues. Yesterday morning our DBA changed the recyclebin to OFF and failed over the database back to the original instance.

    We now find that the speed is back to what it was previously. (So there was some problem with this failover DB server.)


    • Article last edited: 10/8/2013
    View article in the Exlibris Knowledge Center
    1. Back to top
      • Retaining z13u on deleted record; "STA $$aDeleted" field
      • Retrieval Service in preparation for p_cir_77
    • 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