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

DSpace 5.6 is missing a database index on metadatavalue.resource_type_id

    XMLWordPrintable

    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
            Reviewer:
            Kim Shepherd Kim Shepherd
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

              Dates

              Created:
              Updated:
              Resolved: