Uploaded image for project: 'Talend Component Kit'
  1. Talend Component Kit
  2. TCOMP-2541

Improve performance on dynamic column

Apply templateInsert Lucidchart DiagramXMLWordPrintable

    • Hide

      1- Run attachment job 'JDBC_mysql_performance.zip' to prepare the testing data
      2- Run attachment job 'JDBC_mysql_performance2.zip' to retrieve 60 million records

      Show
      1- Run attachment job 'JDBC_mysql_performance.zip' to prepare the testing data 2- Run attachment job 'JDBC_mysql_performance2.zip' to retrieve 60 million records
    • All
    • Small

      Use tJDBCInput to retrieve 60 million records with dynamic column. Compare between tCompV0 and TCK framework

      Framework First Exec Second Exec Third Exec
      tCompV0 346s 337s 416s
      TCK 1112s 1124s 1293s

      The execution time of TCK tJDBCInput is twice more than tCompV0's.

        1. JDBC_mysql_performance.zip
          58 kB
        2. JDBC_mysql_performance2.zip
          53 kB
        3. Screen Shot 2023-09-25 at 16.49.51.png
          Screen Shot 2023-09-25 at 16.49.51.png
          1.96 MB
        4. Screen Shot 2023-09-27 at 10.05.19.png
          Screen Shot 2023-09-27 at 10.05.19.png
          1.74 MB

            Unassigned Unassigned
            qyliu qiyan liu
            Wei Wang
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

              Created:
              Updated:
              Resolved: