Uploaded image for project: 'Alfresco One Platform'
  1. Alfresco One Platform
  2. ACE-3948

BM-0004: Factor out select on alf_content_url table during file creation

    Details

      Description

      When running the benchmark dataload test, one of the most frequent statements appearing in the database tasks is a select on the alf_content_url table.

      select
                  u.id as id,
                  u.content_url as content_url,
                  u.content_url_short as content_url_short,
                  u.content_url_crc as content_url_crc,
                  u.content_size as content_size,
                  u.orphan_time as orphan_time,
                  ce.algorithm as algorithm,
                  ce.key_size as key_size,
                  ce.encrypted_key as encrypted_key,
                  ce.master_keystore_id as master_keystore_id,
                  ce.master_key_alias as master_key_alias,
                  ce.unencrypted_file_size as unencrypted_file_size
              from
                  alf_content_url u
                  left join alf_content_url_encryption ce on (u.id = ce.content_url_id)
              where
                  content_url_short = 'e":"109613"}' and
                  content_url_crc = 2442107221
      

      This select adds overhead and should be factored out, if possible.

      To reproduce, run the benchmark dataload application with file spoofing and profile the SQL calls made.

        Attachments

          Issue Links

            Structure

              Activity

                People

                • Assignee:
                  closedissues Closed Issues
                  Reporter:
                  dhulley Derek Hulley [X] (Inactive)
                • Votes:
                  0 Vote for this issue
                  Watchers:
                  2 Start watching this issue

                  Dates

                  • Created:
                    Updated:
                    Resolved:

                    Structure Helper Panel