Uploaded image for project: 'camunda BPM'
  1. camunda BPM
  2. CAM-9838

Job acquisition should only select columns that are required by the command

    XMLWordPrintable

    Details

      Description

      Currently, the job acquisition query uses SELECT * to fetch all properties of a job. However, the command currently only requires these columns:

      * ID_
      * IS_EXCLUSIVE_
      * PROC_INST_ID_
      * REVISION_
      

      Reducing the select to those columns would allow users to create composite indexes on the columns used in the query such that the query can be answered by index access only.

      Furthermore, the command must be able to write LOCK_OWNER_ and LOCK_EXPIRATION_TIME_.

        Attachments

          Activity

            People

            Assignee:
            nikola.koevski Nikola Koevski
            Reporter:
            thorben.lindhauer Thorben Lindhauer
            Votes:
            1 Vote for this issue
            Watchers:
            4 Start watching this issue

              Dates

              Created:
              Updated:
              Resolved: