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

Improve database efficiency

    XMLWordPrintable

    Details

    • Type: Improvement
    • Status: Closed (View Workflow)
    • Priority: Minor
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: 1.7.0
    • Component/s: None
    • Labels:
      None
    • Attachments:
      0
    • Comments:
      0
    • Documentation Status:
      Not Required

      Description

      Improve various parts of database access - ie.

      • PreparedStatement and parameterized access for getnextid() (relatively expensive as a statement / unparameterized)
      • Where possible, convert DatabaseManager.create() / DatabaseManager.update() to DatabaseManager.row() / DatabaseManager.insert() (delay inserting records until you have the rest of the data for the row, thereby reducing an INSERT / UPDATE sequence to just an INSERT.

        Attachments

          Activity

            People

            Assignee:
            grahamtriggs Graham Triggs
            Reporter:
            grahamtriggs Graham Triggs
            Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

              Dates

              Created:
              Updated:
              Resolved: