question PutDatabaseRecord UPDATE takes too long in Support Questions

question PutDatabaseRecord UPDATE takes too long in Support Questions https://community.cloudera.com/t5/Support-Questions/PutDatabaseRecord-UPDATE-takes-too-long/m-p/383257#M244863 After the LookupRecord, we have the csv file of matched case(as shown in the table below). Then we want to UPDATE using PutDatabase Record for those that matched. The in between: UpdateRecord and JoltTransformations is to add in an attribute and select the attributes we want to use respectively. In the database, where the concat_columns are matched, we want to update that row in our database. However, the updating process takes very long. Could anyone provide some reasons to why?On the other hand,  there are unmatched scenarios, where we then INSERT the row to our database. That is successful and quick. Answers are greatly appreciated! (our flow overview)<img src="https://community.cloudera.com/t5/image/serverpage/image-id/39656iD44B490D1739C79C/image-size/medium?v=v2&px=400" role="button" title="ggyx_1-1707300878884.png" alt="ggyx_1-1707300878884.png" />(UpdateRecord to add a column) <img src="https://community.cloudera.com/t5/image/serverpage/image-id/39658i446ED500A7D40D15/image-size/medium?v=v2&px=400" role="button" title="ggyx_3-1707301613988.png" alt="ggyx_3-1707301613988.png" />(jolt transformation details)<img src="https://community.cloudera.com/t5/image/serverpage/image-id/39657iF4E798C5409E2FC6/image-size/medium?v=v2&px=400" role="button" title="ggyx_2-1707301206078.png" alt="ggyx_2-1707301206078.png" />(Update PutdatabaseRecord Configurations)<img src="https://community.cloudera.com/t5/image/serverpage/image-id/39655i9A59C50B4F4700DC/image-size/medium?v=v2&px=400" role="button" title="ggyx_0-1707300822172.png" alt="ggyx_0-1707300822172.png" />(Dataset of matched) <TABLE width="3771"><TBODY><TR><TD width="64">REVISION_ID</TD><TD width="64">FLAG</TD><TD width="64">ID_BB_UNIQUE</TD><TD width="64">FISCAL_YEAR_PERIOD</TD><TD width="64">LATEST_PERIOD_END_DT_FULL_RECORD</TD><TD width="64">ANNOUNCEMENT_DT</TD><TD width="64">FUNDAMENTAL_ENTRY_DT</TD><TD width="64">FUNDAMENTAL_UPDATE_DT</TD><TD width="64">EQY_CONSOLIDATED</TD><TD width="64">FILING_STATUS</TD><TD width="64">ACCOUNTING_STANDARD</TD><TD width="64">EQY_FUND_CRNCY</TD><TD width="64">ID_BB_COMPANY</TD><TD width="64">AVAILABLE_DATE</TD><TD width="64">announcement_date</TD><TD width="64">period_end</TD><TD width="64">fiscal_period</TD><TD width="64">fiscal_year</TD><TD width="64">update_date</TD><TD width="107">entry_date</TD><TD width="276">Fundamentals_type_ID</TD><TD width="188">COMPANY_ID</TD><TD width="64">filing_status_ID</TD><TD width="64">accounting_standard_ID</TD><TD width="64">fiscal_period_ID</TD><TD width="64">is_consolidated</TD><TD width="64">Concat_columns</TD><TD width="64">root</TD><TD width="64"> </TD><TD width="64"> </TD><TD width="64"> </TD><TD width="64"> </TD><TD width="64"> </TD><TD width="64"> </TD><TD width="64"> </TD><TD width="64"> </TD><TD width="64"> </TD><TD width="64"> </TD><TD width="64"> </TD><TD width="64"> </TD><TD width="64"> </TD><TD width="64"> </TD><TD width="64"> </TD><TD width="64"> </TD><TD width="64"> </TD><TD width="64"> </TD><TD width="64"> </TD><TD width="64"> </TD><TD width="64"> </TD><TD width="64"> </TD><TD width="64"> </TD><TD width="64"> </TD><TD width="64"> </TD></TR><TR><TD>305945</TD><TD>1</TD><TD>EQ0011769300001000</TD><TD>2024 Q2</TD><TD>20230930</TD><TD>20231024</TD><TD>20231114</TD><TD>20231120</TD><TD>Y</TD><TD>OR</TD><TD>JP GAAP</TD><TD>6</TD><TD>117693</TD><TD>########</TD><TD>########</TD><TD>########</TD><TD>Q2</TD><TD>2024</TD><TD>########</TD><TD>11/14/2023</TD><TD>1</TD><TD>2964</TD><TD>2</TD><TD>67</TD><TD>22</TD><TD>1</TD><TD>2964_2024_2023-09-30_1_6_2_67_22_1_EQ0011769300001000</TD><TD>MapRecord[{Announcement_date=2023-10-24, ID_BB_COMPANY=117693, Fiscal_period_ID=22, Filing_status_ID=2, ID_BB_UNIQUE=EQ0011769300001000, Is_consolidated=1, Fiscal_year=2024, EQY_FUND_CRNCY=6, Flag=1, Update_date=2024-01-04, Fundamentals_type_ID=1, Concat_columns=2964_2024_2023-09-30_1_6_2_67_22_1_EQ0011769300001000, Accounting_standard_ID=67, Latest_period_end=2023-09-30, U3_ID_FS=null, Revision=305442, Company_ID=2964, Available_date=2023-10-24, Update_lock=0, ID=356218684, CLEANUP_FLAG=1, Entry_date=2023-11-14}]</TD></TR><TR><TD>305945</TD><TD>1</TD><TD>EQ0011769300001000</TD><TD>2024 Q2</TD><TD>20230930</TD><TD>20231024</TD><TD>20231114</TD><TD>20231120</TD><TD>Y</TD><TD>MR</TD><TD>JP GAAP</TD><TD>6</TD><TD>117693</TD><TD>########</TD><TD>########</TD><TD>########</TD><TD>Q2</TD><TD>2024</TD><TD>########</TD><TD>11/14/2023</TD><TD>1</TD><TD>2964</TD><TD>1</TD><TD>67</TD><TD>22</TD><TD>1</TD><TD>2964_2024_2023-09-30_1_6_1_67_22_1_EQ0011769300001000</TD><TD>MapRecord[{Announcement_date=2023-10-24, ID_BB_COMPANY=117693, Fiscal_period_ID=22, Filing_status_ID=1, ID_BB_UNIQUE=EQ0011769300001000, Is_consolidated=1, Fiscal_year=2024, EQY_FUND_CRNCY=6, Flag=1, Update_date=2024-01-04, Fundamentals_type_ID=1, Concat_columns=2964_2024_2023-09-30_1_6_1_67_22_1_EQ0011769300001000, Accounting_standard_ID=67, Latest_period_end=2023-09-30, U3_ID_FS=null, Revision=305442, Company_ID=2964, Available_date=2023-10-24, Update_lock=0, ID=355964254, CLEANUP_FLAG=1, Entry_date=2023-11-14}]</TD></TR><TR><TD>305945</TD><TD>1</TD><TD>EQ0011769300001000</TD><TD>2024 C2</TD><TD>20230930</TD><TD>20231024</TD><TD>20231114</TD><TD>20231120</TD><TD>Y</TD><TD>OR</TD><TD>JP GAAP</TD><TD>6</TD><TD>117693</TD><TD>########</TD><TD>########</TD><TD>########</TD><TD>C2</TD><TD>2024</TD><TD>########</TD><TD>11/14/2023</TD><TD>1</TD><TD>2964</TD><TD>2</TD><TD>67</TD><TD>32</TD><TD>1</TD><TD>2964_2024_2023-09-30_1_6_2_67_32_1_EQ0011769300001000</TD><TD>MapRecord[{Announcement_date=2023-10-24, ID_BB_COMPANY=117693, Fiscal_period_ID=32, Filing_status_ID=2, ID_BB_UNIQUE=EQ0011769300001000, Is_consolidated=1, Fiscal_year=2024, EQY_FUND_CRNCY=6, Flag=1, Update_date=2024-01-04, Fundamentals_type_ID=1, Concat_columns=2964_2024_2023-09-30_1_6_2_67_32_1_EQ0011769300001000, Accounting_standard_ID=67, Latest_period_end=2023-09-30, U3_ID_FS=null, Revision=305442, Company_ID=2964, Available_date=2023-10-24, Update_lock=0, ID=356219117, CLEANUP_FLAG=1, Entry_date=2023-11-14}]</TD></TR><TR><TD>305945</TD><TD>1</TD><TD>EQ0011769300001000</TD><TD>2024 C2</TD><TD>20230930</TD><TD>20231024</TD><TD>20231114</TD><TD>20231120</TD><TD>Y</TD><TD>MR</TD><TD>JP GAAP</TD><TD>6</TD><TD>117693</TD><TD>########</TD><TD>########</TD><TD>########</TD><TD>C2</TD><TD>2024</TD><TD>########</TD><TD>11/14/2023</TD><TD>1</TD><TD>2964</TD><TD>1</TD><TD>67</TD><TD>32</TD><TD>1</TD><TD>2964_2024_2023-09-30_1_6_1_67_32_1_EQ0011769300001000</TD><TD>MapRecord[{Announcement_date=2023-10-24, ID_BB_COMPANY=117693, Fiscal_period_ID=32, Filing_status_ID=1, ID_BB_UNIQUE=EQ0011769300001000, Is_consolidated=1, Fiscal_year=2024, EQY_FUND_CRNCY=6, Flag=1, Update_date=2024-01-04, Fundamentals_type_ID=1, Concat_columns=2964_2024_2023-09-30_1_6_1_67_32_1_EQ0011769300001000, Accounting_standard_ID=67, Latest_period_end=2023-09-30, U3_ID_FS=null, Revision=305442, Company_ID=2964, Available_date=2023-10-24, Update_lock=0, ID=355964310, CLEANUP_FLAG=1, Entry_date=2023-11-14}]</TD></TR><TR><TD>305945</TD><TD>1</TD><TD>EQ0011769300001000</TD><TD>2024 S1</TD><TD>20230930</TD><TD>20231024</TD><TD>20231024</TD><TD>20231120</TD><TD>Y</TD><TD>PR</TD><TD>JP GAAP</TD><TD>6</TD><TD>117693</TD><TD>########</TD><TD>########</TD><TD>########</TD><TD>S1</TD><TD>2024</TD><TD>########</TD><TD>10/24/2023</TD><TD>1</TD><TD>2964</TD><TD>3</TD><TD>67</TD><TD>11</TD><TD>1</TD><TD>2964_2024_2023-09-30_1_6_3_67_11_1_EQ0011769300001000</TD><TD>MapRecord[{Announcement_date=2023-10-24, ID_BB_COMPANY=117693, Fiscal_period_ID=11, Filing_status_ID=3, ID_BB_UNIQUE=EQ0011769300001000, Is_consolidated=1, Fiscal_year=2024, EQY_FUND_CRNCY=6, Flag=1, Update_date=2024-01-04, Fundamentals_type_ID=1, Concat_columns=2964_2024_2023-09-30_1_6_3_67_11_1_EQ0011769300001000, Accounting_standard_ID=67, Latest_period_end=2023-09-30, U3_ID_FS=null, Revision=305442, Company_ID=2964, Available_date=2023-10-24, Update_lock=0, ID=355964207, CLEANUP_FLAG=1, Entry_date=2023-10-24}]</TD></TR></TBODY></TABLE> Wed, 07 Feb 2024 10:27:31 GMT ggyx 2024-02-07T10:27:31Z