Hi,
Unfortunately I don't understand the root of the problem totally.
Looks like the performance depends linear on rows count:
10k ~ 0.1s
65k ~ 0.65s
650k ~ 7s
I see the linear dependency on rows count...
> Is Ignite doing the join and filtering at each data node and then
sending
> the 650K
Hello!
If you had any images in your email, we are not seeing them. Please provide
links.
Regards,
--
Ilya Kasnacheev
сб, 24 апр. 2021 г. в 03:24, William.L :
> Hi,
>
> I am trying to understand why my colocated join between two tables/caches
> are taking so long compare to the individual
Hi,
I am trying to understand why my colocated join between two tables/caches
are taking so long compare to the individual table filters.
TABLE1
Returns 1 count -- 0.13s
TABLE2
Returns 65000 count -- 0.643s
JOIN TABLE1 and TABLE2
Returns 650K count -- 7s
Both