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

    • EPAM BatchLoader Sprint 26
    • 5
    • 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

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

                Dates

                  Created:
                  Updated:
                  Resolved:

                  TestRail: Runs

                    TestRail: Cases