Forum Discussion

ddangler's avatar
ddangler
New Contributor III
8 years ago
Solved

Join snap performance poor

I have a join snap configured as below(Simple left outer join on Unsorted inputs):

But this join snap is performing very poor. Its throughput is around 0.3 Doc/s. Please refer to the below screenshots:

How can I improve Join snap performance? Thanks!

  • brianrandolph's avatar
    brianrandolph
    8 years ago

    using a sorted join will stream the data according to the documentation, so it would be better to sort before hand.

1 Reply

  • bojanvelevski's avatar
    bojanvelevski
    Valued Contributor
    4 years ago

    Hi @Jarek,

    This sounds like a Collation issue. Check if there’s a Url setting added in the account you are using in the JDBC snaps.

    • Jarek's avatar
      Jarek
      New Contributor
      4 years ago

      Hi @bojanvelevski

      This is what I have in the account settings. Is there a way to add e.g. UTC format or something similar?

      jdbc:teradata://tdwd/TMODE=ANSI,CHARSET=UTF8

      BR,
      Jarek