Uploaded image for project: 'mod-source-record-storage'
  1. mod-source-record-storage
  2. MODSOURCE-76

Consider to improve performance of get_record_by_instance_id

    XMLWordPrintable

    Details

    • Template:
    • Sprint:
      EPAM BatchLoader Sprint 26
    • Story Points:
      5
    • Development Team:
      Folijet

      Description

      During BugFest q3.2-2019 testing, noticed below in SQL log. Please consider to improve the performance of get_record_by_instance_id.

      2019-09-20 18:25:53 UTC:10.23.44.17(36340):mod_source_record_storage:[1202]:LOG: duration: 154.716 ms statement: select get_record_by_instance_id('1e7f577e-57d3-4ab8-9eb3-4dbed2be4f6a');
      2019-09-20 18:25:59 UTC:10.23.44.17(36340):mod_source_record_storage:[1202]:LOG: duration: 150.895 ms statement: select get_record_by_instance_id('1e7f577e-57d3-4ab8-9eb3-4dbed2be4f6a');
      2019-09-20 18:26:06 UTC:10.23.44.149(41884):mod_source_record_storage:[1375]:LOG: duration: 165.248 ms statement: select get_record_by_instance_id('1e7f577e-57d3-4ab8-9eb3-4dbed2be4f6a');
      2019-09-20 18:26:06 UTC:10.23.44.149(41884):mod_source_record_storage:[1375]:LOG: duration: 148.782 ms statement: select get_record_by_instance_id('1e7f577e-57d3-4ab8-9eb3-4dbed2be4f6a');
      2019-09-20 18:28:45 UTC:10.23.44.17(37210):mod_source_record_storage:[3979]:LOG: duration: 166.321 ms statement: select get_record_by_instance_id('1e7f577e-57d3-4ab8-9eb3-4dbed2be4f6a');
      2019-09-20 18:28:45 UTC:10.23.44.149(42426):mod_source_record_storage:[4011]:LOG: duration: 157.277 ms statement: select get_record_by_instance_id('1e7f577e-57d3-4ab8-9eb3-4dbed2be4f6a');
      2019-09-20 18:28:57 UTC:10.23.44.149(42426):mod_source_record_storage:[4011]:LOG: duration: 168.448 ms statement: select get_record_by_instance_id('5e469d5f-3391-443a-9edd-799d167cb359');
      2019-09-20 18:29:02 UTC:10.23.44.149(42426):mod_source_record_storage:[4011]:LOG: duration: 164.073 ms statement: select get_record_by_instance_id('5e469d5f-3391-443a-9edd-799d167cb359');
      2019-09-20 18:29:16 UTC:10.23.44.149(42426):mod_source_record_storage:[4011]:LOG: duration: 148.496 ms statement: select get_record_by_instance_id('5e469d5f-3391-443a-9edd-799d167cb359');
      

      Steps

      1. change schema of record in mod-srs and add additional fields for storing external ids
      2. fill external ids in mod-srm during the parsing together with 999 tags
      3. add indexes

        TestRail: Results

          Attachments

            Issue Links

              Activity

                People

                Assignee:
                ruslan_lavrov Ruslan Lavrov
                Reporter:
                hji Hongwei Ji
                Votes:
                0 Vote for this issue
                Watchers:
                1 Start watching this issue

                  Dates

                  Created:
                  Updated:
                  Resolved:

                    TestRail: Runs

                      TestRail: Cases