Uploaded image for project: 'DSpace'
  1. DSpace
  2. DS-3563

DSpace 5.6 is missing a database index on metadatavalue.resource_type_id

    Details

    • Attachments:
      1
    • Comments:
      2
    • Documentation Status:
      Not Required

      Description

      DSpace 5.6 is missing an index in table "metadatavalue" on column "resource_type_id". This column is used in a query which is executed very frequently:

      For one repository, we saw a drastic change in DB processing time after applying the index:

      As you can see in the screenshot, the processing time for the metadatavalue select went down a lot while the actual amount of requests to the database (calls per minute, cpm) remained the same.

       

        Attachments

          Activity

            People

            • Assignee:
              kshepherd Kim Shepherd
              Reporter:
              tom.desair Tom Desair (Atmire)
              Reviewer:
              Kim Shepherd
            • Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: