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

            Assignee:
            Nikola Koevski
            Reporter:
            Thorben Lindhauer
            Votes:
            1 Vote for this issue
            Watchers:
            4 Start watching this issue

              Created:
              Updated:
              Resolved: