Uploaded image for project: 'CloverDX'
  1. CloverDX
  2. CLO-13377

JDBC connections are opened sequentially

    XMLWordPrintable

    Details

    • QA Testing:
      GUI manual test
    • Steps to reproduce:
      Hide

      Use Clumsy, set Filtering to outbound and ip.DstAddr == 172.22.2.20 (koule IP) and Lag to 1000 ms:

      Run SlowDB.grf with one component enabled and with 10 components enabled.
      It took ~20s with one component and ~200s with 10 components. It should be much faster, the components should run in parallel.

      Show
      Use Clumsy , set Filtering to outbound and ip.DstAddr == 172.22.2.20 (koule IP) and Lag to 1000 ms: Run SlowDB.grf with one component enabled and with 10 components enabled. It took ~20s with one component and ~200s with 10 components. It should be much faster, the components should run in parallel.

      Description

      When a graph contains one DB connection that is used by multiple DBInputTable components, only one component can open a connection at a time. When the connection is slow (high latency), it makes the graph run unnecessarily long.

      Probably caused by the fact that
      org.jetel.connection.jdbc.DBConnectionImpl.getConnection(String, OperationType) is synchronized.

        Attachments

          Issue Links

            Activity

              People

              Assignee:
              krivanekm Milan Krivanek
              Reporter:
              krivanekm Milan Krivanek
              Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved:

                  Time Tracking

                  Estimated:
                  Original Estimate - Not Specified
                  Not Specified
                  Remaining:
                  Remaining Estimate - 0 minutes
                  0m
                  Logged:
                  Time Spent - 3 hours
                  3h