Profiling - 2023.2 English

The hash anti-join desgin is validated on Alveo U280 board at 250 MHz frequency. The hardware resource utilizations are listed in the following table.

Table 31 Table 1 Hardware resources for hash anti-join

Name	LUT	BRAM	URAM	DSP
Platform	130442	204	0	4
join_kernel	134647	291	192	99
User Budget	1172278	1812	960	9020
Percentage	11.49%	16.06%	20.00%	1.10%

The performance is shown below.

In above test, table Lineitem has 3 columns and 6001215 rows and Orders does 1 column and 227597 rows. This means that the design takes 342.568ms to process 69.55MB, so it achieves 203.02MB/s throughput.