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

      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_.

        This is the controller panel for Smart Panels app

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

                Created:
                Updated:
                Resolved: