I am trying to compare 2 different Tables against each other, so the best idea i came up with was something like the one in the Picture. From the bottom left side Comes a Table with roughly 20.000 rows and the top left one provides me with another table with about 5.000 rows.
Now i have to check each of the 20k rows with each of the 5k ones...
my Problem is, that executing this is suuuuper slow. it takes like 30min to finish.
I thought that my code may be slow, but i only have 2 for each Loops (every table has its Information stored in an Array) plus 1 comparation..
The other Thing is.. the Loop end node is creating new rows instead of overwriting the old ones. is there a better way to get the results? i am just incrementing a number based on the Java snippet
Hope i explained my Problem somehow understandable.